Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel prompts to save when no changes made

Whenever I open an Excel file I am ALWAYS prompted to save my changes, even
when I made no changes. I do not have any volitale functions. There is
another computer in the office where this does not happen. We are both
running Excel 2003. I cannot find a setting where I can fix this. I do
notice that if I create the file and save it to our server, then it does not
ask me to save when I open it (ok, so not always). However, there are
numerous files on our server that were created using an older version of
Excel, and I am ALWAYS prompted to save changes, but my co-worker's computer
does not prompt. What setting would be different?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel prompts to save when no changes made

There are no volatile functions or charts. When I open a file save it and
close it, then I go and re-open it, it will still ask me to save my changes
(with no changes being made). It's is very frustrating. Thanks for the
help, but still looking for a solution. Anyone?

"Bernard Liengme" wrote:

As far as I recall Excel gives this message regardless any users changes
being made when:
1) there are volatile function such as NOW, TODAY...
2) the workbook contains a chart
3) the version opening the file is newer than the on that last saved the
file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"CPA Jeff" <CPA wrote in message
...
Whenever I open an Excel file I am ALWAYS prompted to save my changes,
even
when I made no changes. I do not have any volitale functions. There is
another computer in the office where this does not happen. We are both
running Excel 2003. I cannot find a setting where I can fix this. I do
notice that if I create the file and save it to our server, then it does
not
ask me to save when I open it (ok, so not always). However, there are
numerous files on our server that were created using an older version of
Excel, and I am ALWAYS prompted to save changes, but my co-worker's
computer
does not prompt. What setting would be different?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save Prompts PMOPS Excel Worksheet Functions 1 August 26th 08 05:40 PM
print prompts save as des New Users to Excel 5 November 27th 06 03:08 PM
Excel prompts me to save a copy or overwrite file. Vinny Excel Worksheet Functions 0 May 20th 05 03:05 PM
Exiting Excel prompts for save MXH Excel Discussion (Misc queries) 3 February 22nd 05 09:31 PM
Save Excel file - prompts to save - no Volitile functions used POWER CERTS Excel Worksheet Functions 2 November 1st 04 10:27 PM


All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"