Hi, is there a way to prevent the formulas in a spreadsheet from automatically updating, especially when the file is just opened, unless specifically given the ok?
for example, in workbook1-sheet1, I have formulas referencing cells in another workbook. Every time I open workbook1, all the cells with formulas have a #REF! because I haven't opened the other workbook yet. Is there a way for the workbook to open, but not run the formulas until I say to.
thanks
Yes.
Go to Formulas tab. And set calculation option to Manual.
0.JPG
Note that this setting will carry across workbooks.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
No, excel files always calc on opening.Originally Posted by richx
I suspect you are using formulas that require the linked file/s to be open, such as INDIRECT. Perhaps changing your formula may help, but we would need to see some samples to give better help.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
To clarify, you can set to manual mode on new workbook then open other workbook from it.
As well, you can set if you want to update links on workbook open or not, in edit links option.
0.JPG
Edit: Tested using SUMIFS(), which does not work on closed workbook.
Last edited by CK76; 07-19-2019 at 08:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks