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 |
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. |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com