Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Save Changes Prompt before Close, when no changes were made

I've read that this happens when there is a function like NOW(),
TODAY(), etc...

However, I am still getting the save changes prompt on a variety of
workbooks despite not having any of these functions. What they do all
have in common though, is they use the SUMIF function quite liberally.
Would this be a cause of this phenomenon, and if not, is there an easy
fix?

Here's an example of a SUMIF function that I believe might be causing
it:

=SUMIF($B$10:$B$370,"SMG Total",J$10:J$370)+SUMIF($B$10:$B$370,"BHT
Total",J$10:J$368)+SUMIF($B$10:$B$370,"GJC
Total",J$10:J$368)+SUMIF($B$10:$B$370,"KAM
Total",J$10:J$368)+SUMIF($B$10:$B$370,"JLY
Total",J$10:J$368)+SUMIF($B$10:$B$370,"MAJ
Total",J$10:J$368)+SUMIF($B$10:$B$370,"RLP
Total",J$10:J$368)+SUMIF($B$10:$B$370,"CCM
Total",J$10:J368)+SUMIF($B$10:$B$370,"KRA
Total",J$10:J$368)+SUMIF($B$10:$B$370,"MEH
Total",J$10:J$368)+SUMIF($B$10:$B$370,"GPA Total",J$10:J$368)+J160

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Save Changes Prompt before Close, when no changes were made

Never mind, I figured it out. After pasting the function, I realized
the SUMIF arguments didn't parallel (368 vs. 370) so even though the
function was calculating correctly, it probably confused Excel. After
I aligned the values, it stopped giving me the changes prompt.

wrote:
I've read that this happens when there is a function like NOW(),
TODAY(), etc...

However, I am still getting the save changes prompt on a variety of
workbooks despite not having any of these functions. What they do all
have in common though, is they use the SUMIF function quite liberally.
Would this be a cause of this phenomenon, and if not, is there an easy
fix?

Here's an example of a SUMIF function that I believe might be causing
it:

=SUMIF($B$10:$B$370,"SMG Total",J$10:J$370)+SUMIF($B$10:$B$370,"BHT
Total",J$10:J$368)+SUMIF($B$10:$B$370,"GJC
Total",J$10:J$368)+SUMIF($B$10:$B$370,"KAM
Total",J$10:J$368)+SUMIF($B$10:$B$370,"JLY
Total",J$10:J$368)+SUMIF($B$10:$B$370,"MAJ
Total",J$10:J$368)+SUMIF($B$10:$B$370,"RLP
Total",J$10:J$368)+SUMIF($B$10:$B$370,"CCM
Total",J$10:J368)+SUMIF($B$10:$B$370,"KRA
Total",J$10:J$368)+SUMIF($B$10:$B$370,"MEH
Total",J$10:J$368)+SUMIF($B$10:$B$370,"GPA Total",J$10:J$368)+J160


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
stop prompt to save on no changes made sam2u Excel Discussion (Misc queries) 1 June 2nd 08 09:07 PM
Intercepting the file save prompt before close? Neil Bhandar[_4_] Excel Programming 3 February 14th 06 04:19 AM
Save Changes Prompt at close Johnewally Excel Discussion (Misc queries) 2 March 17th 05 10:15 PM
Save prompt when no changes made Fred Smith Excel Discussion (Misc queries) 3 January 28th 05 12:42 AM
Excel close/save/prompt problem clayton[_2_] Excel Programming 4 January 22nd 04 12:45 AM


All times are GMT +1. The time now is 12:08 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"