View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default How do I Print multiple spreadsheets at once without having to sa.

In article , "Earl Kiosterud" wrote:
Dawson,

There may be volatile functions (like RAND()) in a worksheet.


Note that there are other volatile functions that do this too of course ...
=today() is the one I'm thinking of. If I open a file with that in and print
it (only, not even a cursor move else), XL tells me there are changes I need
to save. Nice work around :)

Try this. Start Excel. In Tools - Options - Calculation, set calculation to
manual. Leave
the new empty workbook open. This stupidly sets the calc switch to manual for
all
subsequently opened workbooks, possibly a boon in your situation. Now try your
print. I
used the Print command in the right-click menu with selected files in a folder,
and didn't
test this by dragging into a printer as you're doing.

Don't let the workbooks actually get saved, as they'll get saved with the calc
switch set to
manual. No one knows why it's this way, and it's rumored that it'll be fixed
in 2057.