I click 'Save' and it appears to save, then I click Close and Excel asks if I want to save changes?
Any clues as to what might be making Excel think I've done something between saving and closing (when I've not) that warrants the prompt?
Ken
save not saving?
-
- Panoramic Lounger
- Posts: 8197
- Joined: 25 Jan 2010, 09:09
- Location: retirement
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 4936
- Joined: 31 Aug 2016, 09:02
Re: save not saving?
May be your workbook has dynamic named ranges ...
-
- Panoramic Lounger
- Posts: 8197
- Joined: 25 Jan 2010, 09:09
- Location: retirement
Re: save not saving?
The workbook doesn't use TODAY() or NOW() but it does make extensive use of dynamic named ranges. However how they change between clicking Save and Close?
Ken
Ken
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: save not saving?
The mere presence of a dynamic range doesn't explain it, but it depends of the definition.
I'm afraid it's impossible to know what causes the prompt without seeing the workbook.
I'm afraid it's impossible to know what causes the prompt without seeing the workbook.
Best wishes,
Hans
Hans
-
- Panoramic Lounger
- Posts: 8197
- Joined: 25 Jan 2010, 09:09
- Location: retirement
Re: save not saving?
As in the 'recalc before close' could update the named range, even though it returns the same answer and thus it look as if something has changed, when nothing has changed?HansV wrote:...it depends of the definition.
While looking at my named ranges I came across this issue again:
named ranges that refer to =#NAME?
I've removed them again. That might have been the problem as the save and immediately close after I'd done that didn't trigger a save changes prompt.
Yet another instance where telepathy would be handy Sadly but as I think you know, I'm not allowed to upload my workbooks.HansV wrote:...I'm afraid it's impossible to know what causes the prompt without seeing the workbook.
Ken
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands