print prompts save as
 

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

print prompts save as
 

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

Just curious. I'll let the experts explain.

Epinn

"des" wrote in message ...
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

print prompts save as
 

Hi Epinn i dont know what a volatile function is.
--
des


"Epinn" wrote:

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

Just curious. I'll let the experts explain.

Epinn

"des" wrote in message ...
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

print prompts save as
 

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/GoodVsBad...edUpEvents.htm

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

Epinn

"des" wrote in message ...
Hi Epinn i dont know what a volatile function is.
--
des


"Epinn" wrote:

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

Just curious. I'll let the experts explain.

Epinn

"des" wrote in message ...
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

print prompts save as
 

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

Epinn

"Epinn" wrote in message ...
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/GoodVsBad...edUpEvents.htm

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

Epinn

"des" wrote in message ...
Hi Epinn i dont know what a volatile function is.
--
des


"Epinn" wrote:

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

Just curious. I'll let the experts explain.

Epinn

"des" wrote in message ...
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

print prompts save as
 

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"des" wrote in message
...
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