LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Excel chokes when printing multiple charts per page

I have built an excel 2007 file which contains 7-graphs per print page.
Graphs are for Sunday through Saturday and they are simple line graphs.
There are a total of 54-pages of graphs covering many different work areas.
The entire file size is around 10Mb and all graphed data is contained on a
single tab.
Problem - When I select "File, Print, Entire Workbook" excel starts building
a swapfile in the Windows Printer Properties dialogue box which grows to
about 650Mb, takes about 1-hour to complete the printing operation while
freezing all resources on the PC. This excel file was built fresh in v2007.

I built a similar file in Excel 2003 which contained 7-graphs per print
page, sunday through saturday, and total pages was 67. File size was in the
15Mb range. In Excel 2003 I would print the entire workbook yielding 69-pages
of graphed data. The entire print job would take about 15-minutes.

How can I improve the way Excel 2007 handels printing large quantities of
graphs?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing multiple charts Jeff Stanton Charts and Charting in Excel 2 October 16th 08 02:53 PM
Printing multiple page worksheets on 1 single page Hope Excel Discussion (Misc queries) 1 January 7th 07 03:56 AM
excel : printing multiple one page with different titles Dave o Excel Discussion (Misc queries) 1 October 26th 06 06:08 PM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 09:47 PM
Excel - printing multiple worksheets on one page BGA Excel Discussion (Misc queries) 1 February 18th 05 02:05 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"