print prompts save as

[des]

when i try to print an excel 2003 worksheet i am asked to save as instead of
the printing taking place. I havent made any changes to my workbook so i have
nothing to save.

 

[Epinn]

Do you have volatile functions like TODAY( ), NOW( ), OFFSET( ) etc. in your worksheet?

Just curious. I'll let the experts explain.

Epinn

when i try to print an excel 2003 worksheet i am asked to save as instead of
the printing taking place. I havent made any changes to my workbook so i have
nothing to save.

 

[des]

Hi Epinn i dont know what a volatile function is.

 

[Epinn]

The examples I gave in my post - TODAY( ), NOW( ), OFFSET( ) are volatile functions. Do you have any?
"Volatile Functions

Volatile functions are simple functions that will recalculate each time a change of any sort occurs in any cell on any worksheet. Most functions will only recalculate if a cell which they are referencing has changed. Some of the most common volatile functions used are undoubtedly the NOW() and TODAY() functions. If you are going to be using the result of these functions frequently throughout your spreadsheet, avoid the temptation of nesting these functions within other functions to get your desired result. Instead, simply type the volatile function into a single cell on your spreadsheet and reference that cell from within other functions. This alone can potentially cut down on the amount of volatile functions by hundreds, if not thousands at times."

Source: http://www.ozgrid.com/News/GoodVsBadDesignSpeedUpEvents.htm

Please wait for the experts. I am just curious if you have any volatile functions in your worksheet.

Epinn

Hi Epinn i dont know what a volatile function is.

 

[Epinn]

I don't want to confuse you. You can ignore the second part of the quote starting with "If you are going to ......"

Epinn

The examples I gave in my post - TODAY( ), NOW( ), OFFSET( ) are volatile functions. Do you have any?
"Volatile Functions

Volatile functions are simple functions that will recalculate each time a change of any sort occurs in any cell on any worksheet. Most functions will only recalculate if a cell which they are referencing has changed. Some of the most common volatile functions used are undoubtedly the NOW() and TODAY() functions. If you are going to be using the result of these functions frequently throughout your spreadsheet, avoid the temptation of nesting these functions within other functions to get your desired result. Instead, simply type the volatile function into a single cell on your spreadsheet and reference that cell from within other functions. This alone can potentially cut down on the amount of volatile functions by hundreds, if not thousands at times."

Source: http://www.ozgrid.com/News/GoodVsBadDesignSpeedUpEvents.htm

Please wait for the experts. I am just curious if you have any volatile functions in your worksheet.

Epinn

Hi Epinn i dont know what a volatile function is.

 

[Bernard Liengme]

How do you initiate the print? Are you clicking a toolbar icon? Maybe it has
been changed to issue a Save command. Try File | Print.
Any help?