If there are no macros in the workbook then there must be code in another
workbook or add-in which is doing this.

Have you tried on another PC?

Tim


"Mick" wrote in message
...
I have a spread sheet that generates formulas in blank cells that doesn't
use
any macros for doing this that I can find. I posted this on 9/23/07 and
GLWhiz made some recommendations but nothing has resolved the problem. I
would appreciate it if someone would please look at this problem and
explain
how I can change the formulsa?

Regards
Mck

Yes, I did copy the work book to another computer(Windows XP) using Excel
2003 and it did the same thing. I also copied just cells to a blank workbook
and then it did the same thing.
--
Regards
Mck


"Tim Williams" wrote:

If there are no macros in the workbook then there must be code in another
workbook or add-in which is doing this.

Have you tried on another PC?

Tim


"Mick" wrote in message
...
I have a spread sheet that generates formulas in blank cells that doesn't
use
any macros for doing this that I can find. I posted this on 9/23/07 and
GLWhiz made some recommendations but nothing has resolved the problem. I
would appreciate it if someone would please look at this problem and
explain
how I can change the formulsa?

Regards
Mck

If you like you can send me a copy by email.

Tim
tim j williams at gmail dot com no spaces

"Mick" wrote in message
...
Yes, I did copy the work book to another computer(Windows XP) using Excel
2003 and it did the same thing. I also copied just cells to a blank
workbook
and then it did the same thing.
--
Regards
Mck


"Tim Williams" wrote:

If there are no macros in the workbook then there must be code in another
workbook or add-in which is doing this.

Have you tried on another PC?

Tim


"Mick" wrote in message
...
I have a spread sheet that generates formulas in blank cells that
doesn't
use
any macros for doing this that I can find. I posted this on 9/23/07
and
GLWhiz made some recommendations but nothing has resolved the problem.
I
would appreciate it if someone would please look at this problem and
explain
how I can change the formulsa?

Regards
Mck

Anyone care to take a look at this? I've not seen it before. I got a copy
of the workbook from Mick, and it is as described: no macros, no "hidden"
formulas.
I saved out the file in xml format and combed though it - no hint there
either. Re-openeing the xml file in Excel preserved the effect.

For those wary of opening an xls file I've pasted the xml format content
below. Enter a value in B10.

Tim

*********************
<?xml version="1.0"?
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"
<AuthorMick</Author
<LastAuthorTim</LastAuthor
<Created2007-09-22T20:37:22Z</Created
<LastSaved2007-09-24T02:58:06Z</LastSaved
<CompanyHome</Company
<Version10.6830</Version
</DocumentProperties
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"
<DownloadComponents/
<LocationOfComponents HRef="/"/
</OfficeDocumentSettings
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"
<WindowHeight8580</WindowHeight
<WindowWidth15180</WindowWidth
<WindowTopX0</WindowTopX
<WindowTopY60</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</ProtectWindows
</ExcelWorkbook
<Styles
<Style ss:ID="Default" ss:Name="Normal"
<Alignment ss:Vertical="Bottom"/
<Borders/
<Font/
<Interior/
<NumberFormat/
<Protection/
</Style
<Style ss:ID="s20" ss:Name="Percent"
<NumberFormat ss:Format="0%"/
</Style
<Style ss:ID="m12870750"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/
</Borders
<Font ss:Color="#0000FF"/
</Style
<Style ss:ID="m12870760"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/
</Borders
</Style
<Style ss:ID="s21"
<NumberFormat ss:Format="Short Date"/
</Style
<Style ss:ID="s22"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/
</Style
<Style ss:ID="s24"
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/
</Borders
<Font ss:Color="#0000FF"/
</Style
<Style ss:ID="s37"
<NumberFormat ss:Format="0%"/
</Style
<Style ss:ID="s39" ss:Parent="s20"
<NumberFormat ss:Format="Percent"/
</Style
<Style ss:ID="s40" ss:Parent="s20"
<Font ss:Color="#0000FF"/
<NumberFormat ss:Format="Percent"/
</Style
<Style ss:ID="s41"
<NumberFormat ss:Format="0"/
</Style
<Style ss:ID="s42" ss:Parent="s20"
<Font ss:Color="#0000FF"/
<NumberFormat ss:Format="0"/
</Style
<Style ss:ID="s43" ss:Parent="s20"
<Borders/
<Font/
<Interior/
<NumberFormat ss:Format="Percent"/
</Style
<Style ss:ID="s45"
<Font ss:Color="#0000FF"/
</Style
</Styles
<Worksheet ss:Name="Sheet1"
<Table ss:ExpandedColumnCount="10" ss:ExpandedRowCount="12"
x:FullColumns="1"
x:FullRows="1"
<Row ss:Index="3"
<Cell ss:StyleID="s21"/
<Cell ss:MergeAcross="2" ss:StyleID="s22"<Data ss:Type="String"Running
Total</Data</Cell
<Cell ss:MergeAcross="1" ss:StyleID="m12870750"<Data
ss:Type="String"Session</Data</Cell
<Cell ss:Index="8" ss:MergeAcross="2" ss:StyleID="m12870760"<Data
ss:Type="String"Wins to Reach </Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"/
<Cell ss:StyleID="s22"<Data ss:Type="String"Losses</Data</Cell
<Cell ss:StyleID="s22"<Data ss:Type="String"Wins</Data</Cell
<Cell ss:StyleID="s22"<Data ss:Type="String"%</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"Total </Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"%</Data</Cell
<Cell ss:Index="8" ss:StyleID="s37"<Data
ss:Type="Number"0.7</Data</Cell
<Cell ss:StyleID="s37"<Data ss:Type="Number"0.71</Data</Cell
<Cell ss:StyleID="s37"<Data ss:Type="Number"0.75</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"2007-08-18T00:00:00.000</Data</Cell
<Cell<Data ss:Type="Number"575</Data</Cell
<Cell<Data ss:Type="Number"1329</Data</Cell
<Cell ss:StyleID="s39" ss:Formula="=RC[-1]/(RC[-2]+RC[-1])"<Data
ss:Type="Number"0.69800420168067223</Data</Cell
<Cell ss:StyleID="s40"/
<Cell ss:StyleID="s40"/
<Cell ss:Index="8" ss:StyleID="s41"
ss:Formula="=RC[-6]/(1-R4C8)-RC[-6]"<Data
ss:Type="Number"1341.6666666666663</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-7]/(1-R4C9)-RC[-7]"<Data
ss:Type="Number"1407.7586206896549</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-8]/(1-R4C10)-RC[-8]"<Data
ss:Type="Number"1725</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"2007-09-01T00:00:00.000</Data</Cell
<Cell<Data ss:Type="Number"615</Data</Cell
<Cell<Data ss:Type="Number"1415</Data</Cell
<Cell ss:StyleID="s39" ss:Formula="=RC[-1]/(RC[-2]+RC[-1])"<Data
ss:Type="Number"0.69704433497536944</Data</Cell
<Cell ss:StyleID="s42"
ss:Formula="=RC[-2]-R[-1]C[-2]+RC[-3]-R[-1]C[-3]"<Data
ss:Type="Number"126</Data</Cell
<Cell ss:StyleID="s40" ss:Formula="=(RC[-3]-R[-1]C[-3])/RC[-1]"<Data
ss:Type="Number"0.68253968253968256</Data</Cell
<Cell ss:Index="8" ss:StyleID="s41"
ss:Formula="=RC[-6]/(1-R4C8)-RC[-6]"<Data
ss:Type="Number"1434.9999999999995</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-7]/(1-R4C9)-RC[-7]"<Data
ss:Type="Number"1505.6896551724135</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-8]/(1-R4C10)-RC[-8]"<Data
ss:Type="Number"1845</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"2007-09-02T00:00:00.000</Data</Cell
<Cell<Data ss:Type="Number"627</Data</Cell
<Cell<Data ss:Type="Number"1439</Data</Cell
<Cell ss:StyleID="s39" ss:Formula="=RC[-1]/(RC[-2]+RC[-1])"<Data
ss:Type="Number"0.69651500484027107</Data</Cell
<Cell ss:StyleID="s42"
ss:Formula="=RC[-2]-R[-1]C[-2]+RC[-3]-R[-1]C[-3]"<Data
ss:Type="Number"36</Data</Cell
<Cell ss:StyleID="s40" ss:Formula="=(RC[-3]-R[-1]C[-3])/RC[-1]"<Data
ss:Type="Number"0.66666666666666663</Data</Cell
<Cell ss:Index="8" ss:StyleID="s41"
ss:Formula="=RC[-6]/(1-R4C8)-RC[-6]"<Data
ss:Type="Number"1462.9999999999995</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-7]/(1-R4C9)-RC[-7]"<Data
ss:Type="Number"1535.0689655172409</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-8]/(1-R4C10)-RC[-8]"<Data
ss:Type="Number"1881</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"2007-09-03T00:00:00.000</Data</Cell
<Cell<Data ss:Type="Number"630</Data</Cell
<Cell<Data ss:Type="Number"1451</Data</Cell
<Cell ss:StyleID="s39" ss:Formula="=RC[-1]/(RC[-2]+RC[-1])"<Data
ss:Type="Number"0.69726093224411345</Data</Cell
<Cell ss:StyleID="s42"
ss:Formula="=RC[-2]-R[-1]C[-2]+RC[-3]-R[-1]C[-3]"<Data
ss:Type="Number"15</Data</Cell
<Cell ss:StyleID="s40" ss:Formula="=(RC[-3]-R[-1]C[-3])/RC[-1]"<Data
ss:Type="Number"0.8</Data</Cell
<Cell ss:Index="8" ss:StyleID="s41"
ss:Formula="=RC[-6]/(1-R4C8)-RC[-6]"<Data
ss:Type="Number"1469.9999999999995</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-7]/(1-R4C9)-RC[-7]"<Data
ss:Type="Number"1542.4137931034479</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-8]/(1-R4C10)-RC[-8]"<Data
ss:Type="Number"1890</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"<Data
ss:Type="DateTime"2007-09-16T00:00:00.000</Data</Cell
<Cell<Data ss:Type="Number"642</Data</Cell
<Cell<Data ss:Type="Number"1493</Data</Cell
<Cell ss:StyleID="s43" ss:Formula="=RC[-1]/(RC[-2]+RC[-1])"<Data
ss:Type="Number"0.69929742388758787</Data</Cell
<Cell ss:StyleID="s42"
ss:Formula="=RC[-2]-R[-1]C[-2]+RC[-3]-R[-1]C[-3]"<Data
ss:Type="Number"54</Data</Cell
<Cell ss:StyleID="s40" ss:Formula="=(RC[-3]-R[-1]C[-3])/RC[-1]"<Data
ss:Type="Number"0.77777777777777779</Data</Cell
<Cell ss:Index="8" ss:StyleID="s41"
ss:Formula="=RC[-6]/(1-R4C8)-RC[-6]"<Data
ss:Type="Number"1497.9999999999995</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-7]/(1-R4C9)-RC[-7]"<Data
ss:Type="Number"1571.7931034482758</Data</Cell
<Cell ss:StyleID="s41" ss:Formula="=RC[-8]/(1-R4C10)-RC[-8]"<Data
ss:Type="Number"1926</Data</Cell
</Row
<Row
<Cell ss:StyleID="s21"/
<Cell ss:Index="4" ss:StyleID="s43"/
<Cell ss:StyleID="s45"/
<Cell ss:StyleID="s45"/
<Cell ss:Index="8" ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
</Row
<Row
<Cell ss:Index="8" ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
</Row
<Row
<Cell ss:Index="8" ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
<Cell ss:StyleID="s41"/
</Row
</Table
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<Print
<ValidPrinterInfo/
<HorizontalResolution-3</HorizontalResolution
<VerticalResolution0</VerticalResolution
</Print
<Selected/
<Panes
<Pane
<Number3</Number
<ActiveRow21</ActiveRow
<ActiveCol2</ActiveCol
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<Worksheet ss:Name="Sheet2"
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<Worksheet ss:Name="Sheet3"
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
</Workbook

*********************


"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
If you like you can send me a copy by email.

Tim
tim j williams at gmail dot com no spaces

"Mick" wrote in message
...
Yes, I did copy the work book to another computer(Windows XP) using Excel
2003 and it did the same thing. I also copied just cells to a blank
workbook
and then it did the same thing.
--
Regards
Mck


"Tim Williams" wrote:

If there are no macros in the workbook then there must be code in
another
workbook or add-in which is doing this.

Have you tried on another PC?

Tim


"Mick" wrote in message
...
I have a spread sheet that generates formulas in blank cells that
doesn't
use
any macros for doing this that I can find. I posted this on 9/23/07
and
GLWhiz made some recommendations but nothing has resolved the problem.
I
would appreciate it if someone would please look at this problem and
explain
how I can change the formulsa?

Regards
Mck