Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does Excel see my simple formulae as macros now?
why does Excel see my simple formulae as macros now? Cells will not
automatically recalculate when that function is enabled. virus scan/spyware/firewall all up to date and active. I don't use macros, so how did Excel convert simple "divide this cell by that cell" into macros that don't even work? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does Excel see my simple formulae as macros now?
Not sure what you mean by "see as macros".
Did you check ToolsOptionsCalculation tab, Automatic? Did you check ToolsOptionsView tab, UNcheck Formulas? -- Kind regards, Niek Otten "Chris" wrote in message ... why does Excel see my simple formulae as macros now? Cells will not automatically recalculate when that function is enabled. virus scan/spyware/firewall all up to date and active. I don't use macros, so how did Excel convert simple "divide this cell by that cell" into macros that don't even work? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does Excel see my simple formulae as macros now?
I think you might mean that they show as text rather than the values.
In this case format the cells as general and click F2. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does Excel see my simple formulae as macros now?
yes, those options are set correctly. First, when I tried to reopen the
document, I got a message about macros. I never put macros in the spreadsheet. If I enter new values or change existing values, the spreadsheet does not automatically recalculate...it is "seeing" the formulae and macros that must be run to recalculate. I have Excel 2000. Error massage said macrs were created using Excel 4.0. Never owned Excel 4.0. "Niek Otten" wrote: Not sure what you mean by "see as macros". Did you check ToolsOptionsCalculation tab, Automatic? Did you check ToolsOptionsView tab, UNcheck Formulas? -- Kind regards, Niek Otten "Chris" wrote in message ... why does Excel see my simple formulae as macros now? Cells will not automatically recalculate when that function is enabled. virus scan/spyware/firewall all up to date and active. I don't use macros, so how did Excel convert simple "divide this cell by that cell" into macros that don't even work? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does Excel see my simple formulae as macros now?
that has nothing to do with my issue
"Pete_UK" wrote: I think you might mean that they show as text rather than the values. In this case format the cells as general and click F2. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Macros in Excel(probably a simple solution) | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |