Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop prompt to save on no changes made | Excel Discussion (Misc queries) | |||
Intercepting the file save prompt before close? | Excel Programming | |||
Save Changes Prompt at close | Excel Discussion (Misc queries) | |||
Save prompt when no changes made | Excel Discussion (Misc queries) | |||
Excel close/save/prompt problem | Excel Programming |