Prev: formulas
Next: Can't shift cells up or down
From: AnalystMark on 26 Jan 2010 12:27
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?
From: Jim Thomlinson on 26 Jan 2010 12:42
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?
 | 
Pages: 1
Prev: formulas
Next: Can't shift cells up or down