 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006why 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? Not sure what you mean by "see as macros". Did you check Tools>Options>Calculation tab, Automatic? Did you check Tools>Options>View tab, UNcheck Formulas?  SignatureKind regards, Niek Otten > 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? 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 that has nothing to do with my issue > 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 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. > Not sure what you mean by "see as macros". > Did you check Tools>Options>Calculation tab, Automatic? [quoted text clipped - 5 lines] > > did Excel convert simple "divide this cell by that cell" into macros that > > don't even work? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.