Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Let me save/close EXCEL if a formula I put in has an error in it
Sometimes if I enter a formula in EXCEL and it has an error in it e.g.
incorrect syntax etc. I get frustrated especially if its a long formula and I do not have the time at that moment to find out where the error is. To save any other changes I have made, I have to delete the formula. I would like to save the workbook with the incorrect formula intact so I can return to it and fix it at a later date. -- TonyB ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Let me save/close EXCEL if a formula I put in has an error in it
When Excel refuses to take the formula and tells you something is wrong
acknowledge and hit OK then............. Click in the formula bar and place an apostrophe left of the = sign. This will turn the formula to a text string for later editing. Gord Dibben MS Excel MVP On Fri, 1 Sep 2006 18:21:01 -0700, Tony Borg wrote: Sometimes if I enter a formula in EXCEL and it has an error in it e.g. incorrect syntax etc. I get frustrated especially if its a long formula and I do not have the time at that moment to find out where the error is. To save any other changes I have made, I have to delete the formula. I would like to save the workbook with the incorrect formula intact so I can return to it and fix it at a later date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |