Hidden formulas.2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
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.
 
If you like you can send me a copy by email.

Tim
tim j williams at gmail dot com no spaces
 
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">
<Author>Mick</Author>
<LastAuthor>Tim</LastAuthor>
<Created>2007-09-22T20:37:22Z</Created>
<LastSaved>2007-09-24T02:58:06Z</LastSaved>
<Company>Home</Company>
<Version>10.6830</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<DownloadComponents/>
<LocationOfComponents HRef="/"/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>8580</WindowHeight>
<WindowWidth>15180</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>60</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</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>
<VerticalResolution>0</VerticalResolution>
</Print>
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>21</ActiveRow>
<ActiveCol>2</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>

*********************
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden formulas 8
Compare sheets for matches 2
Insert Row also adds formulas and moves cursor 2
Need help with a Formula 4
Print hidden sheets 2
Averaging Time 8
Print a Single Hidden Worksheet? 4
Macro to remove zerro 7

Back
Top