Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
background commands running in Excel?
I have created a new spreadsheet for some reporting that involves many charts
that feed off one worksheet within the workbook. Every time that I open the workbook, the chart tab names are reset to "chart 1" "chart 2" etc. Also, even if I open the workbook and immediately close it, it asks if I want to save changes. The file is NOT linked to any external files. Is there any way that I can see the internal processes occuring that are changing these tab names and triggering the "save changes" command? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
background commands running in Excel?
Do you have an VBA code running in the workbook? Do you use and volatile
functions such as Now(), Today(), Cells(), Rand(). If code is executing on the On Open event then that would explain the saving behaviour and possibly the chart titles. The volatile functions would definitely explain the need to save the file as they will change cell values when the workbook is opened. -- HTH... Jim Thomlinson "AnalystMark" wrote: I have created a new spreadsheet for some reporting that involves many charts that feed off one worksheet within the workbook. Every time that I open the workbook, the chart tab names are reset to "chart 1" "chart 2" etc. Also, even if I open the workbook and immediately close it, it asks if I want to save changes. The file is NOT linked to any external files. Is there any way that I can see the internal processes occuring that are changing these tab names and triggering the "save changes" command? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Commands greyed out | Setting up and Configuration of Excel | |||
how many commands are there in excel? | Excel Discussion (Misc queries) | |||
Excel commands | Excel Worksheet Functions | |||
How do I restore excel running in the background? | Excel Discussion (Misc queries) | |||
Excel toolbar commands | Excel Worksheet Functions |