I am having trouble with an excel file wanting to save when no changes were made & opening as read only for the 2nd person - but allowing them to save the file.

1) I am having trouble with an excel file wanting to save when no changes were made.  As soon as you open the file and exit.  It prompts for a save.

All excel versions are 15.0.4701.1002.

Using a table.

the functions CELL, OFFSET, TODAY, INDIRECT, NOW, INFO and RAND are not being used.

2) Same file.   2nd person is being told they are opening the file as read only - but when they are quitting excel prompts them to save the file. 

Everything was working fine.  I started having problems with Excel, IT wiped my version out and re-installed office. 

File is on networked server HP - Windows Server 2012 Essentials.  

We are all on Windows 8.1 Pro.

I really hope someone can help - the excel expert had no answer - and passed me along to here.

April 15th, 2015 11:40am

I copied the whole file and started deleting worksheets one at a time and testing it by closing it and re-opening it then closing it again to see if it wanted to save.  Once all the pivot tables were deleted the problem went away.  I found that some of the pivot tables had automatic refresh upon open, so this caused the excel to think data had changed.  It is fixed now.  By clicking on one cell of the pivot table, analyze, options, data and uncheck the 3<sup>rd</sup> square down to not automatically refresh.  NOT A NETWORK ISSUE.


Free Windows Admin Tool Kit Click here and download it now
April 15th, 2015 1:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics