If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#12
|
|||
|
|||
What causes = not to work?
Thanks, Don. I can do that. It's just frustrating because this problem just
popped up out of nowhere and I'm not sure what caused it. Thanks again for the great help! Amy "Don Guillett" wrote: Calculation is set by the method specified in the FIRST file to open If you have book.xlt and it is set to automatic then open it first. I have my excel open to a Menu.xls which does have automatic set by the properties in a desktop button. C:\myfolder\MENU.xls -- Don Guillett Microsoft MVP Excel SalesAid Software "Amy" wrote in message news If I'm opening an existing document, that's true. When I just open Excel, new doc, it is defaulted to manual calc mode. I do this a lot because I'm pasting data from other programs and then running a macro to create a report. How can I set it, so that when I open Excel, it opens in automatic calc mode?? Thanks! "Don Guillett" wrote: Calculation is set by the method specified in the FIRST file to open -- Don Guillett Microsoft MVP Excel SalesAid Software "Rhos" wrote in message ... Okay. the calculation being set to manual seems to the problem. But when I change it to automatic, it reverts to manual the next time I open Excel! Is there somewhere else that I can change this default setting? Thanks to all! Amy "Mike H" wrote: Amy, two thoughts:- is calculation set to manual? Tools|Options - Calculation tab and select auto. Are these cells formatted as text when you enter a formula? Ensure they are formatted as 'general' Mike "Amy" wrote: On several occasions lately I've had the misfortune of my spreadsheet refusing to treat a formula as a formula. Instead it shows me the formula. i.e. "=A2+A4" instead of "16". What causes this??? How do I avoid it? Also, when the formula does work, I'm having an issue when I drag the formula to other cells that it doesn't process unless I manually go into that cell and hit enter. The formula reads correctly, but the result is the same that was in the first cell until I click in the cell and hit enter. (This is not a relative/absolute reference issue) If these ring a bell to anyone...please help!! |
|
Thread Tools | |
Display Modes | |
|
|