Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :\ |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :\ |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :\ |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :\ |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 :\ |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spreadsheets print too small on page | Excel Discussion (Misc queries) | |||
Can't print a group of spreadsheets Excel 2003 | Excel Discussion (Misc queries) | |||
Applying Print Settings to Several Spreadsheets At Once | Excel Discussion (Misc queries) | |||
How do I print spreadsheets on 14x17 paper from my HP 4V | Excel Discussion (Misc queries) | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions |