How do I Print multiple spreadsheets at once without having to sa.
 

Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

How do I Print multiple spreadsheets at once without having to sa.
 

not sure if this will work or not, but have you tried

Application.DisplayAlerts = False

alternatively, if you're utilizing VBA to print these, you could use the
following on workbook close:

activeworkbook.close savechanges=false 'or true if you prefer

hope this helps!
-chad

"Dawson" wrote:

Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

How do I Print multiple spreadsheets at once without having to
 

Hey Chad,
I am selecting all the excel files and dragging them to the printer icon. I
am not utilizing VBA. I just want to mass print 

Dawson


"Chad" wrote:

not sure if this will work or not, but have you tried

Application.DisplayAlerts = False

alternatively, if you're utilizing VBA to print these, you could use the
following on workbook close:

activeworkbook.close savechanges=false 'or true if you prefer

hope this helps!
-chad

"Dawson" wrote:

Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

How do I Print multiple spreadsheets at once without having to sa.
 

Dawson,

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

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.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dawson" wrote in message
...
Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

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.

How do I Print multiple spreadsheets at once without having to
 

I felt I was close, too! I set the options per the previous post.

The error message says:

Do you want to save changes to xxxx.xls?
Microsoft Office Excel recalculates formulas when opening files last saved
by an earlier version of Excel.

Dawson



"Earl Kiosterud" wrote:

Dawson,

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

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.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dawson" wrote in message
...
Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

How do I Print multiple spreadsheets at once without having to sa.
 

Bruce,

Guess it's time to write some code. :)
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Bruce Sinclair" wrote in message
...
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.