If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart sheets cause data sheets to be blank
I'm using XL2000. I have a workbook with 11 sheets, 7 charts and 4 data.
They are intermingled. Whenever I try to print the entire workbook, any data sheet after the first chart is blank. They view fine in print preview, but are blank when actually printed. Has anyone heard of this problem? I can print them one sheet at a time, but I am trying to pass the workbook on to my boss and I don't want him to have to hit print 11 times. We would also like to print to .pdf and don't want 11 files. I need help! LK |
#2
|
|||
|
|||
Possibly this can help . . .
Click once on the first tab of your workbook to activate it. Assuming it is called "Sheet1", the background of the Sheet1 tab should be white. Next, press the Shift key. Finally, go to the last tab in your workbook click on it. Now, all of you sheet tabs should be activated. If you print the workbook, all of the tabs should print as one job. You can save the workbook with all of the tabs activated too. Then, when your boss prints the workbook all of the sheets will print. ---- Regards, John Mansfield http://www.pdbook.com "Jacinthe" wrote: I'm using XL2000. I have a workbook with 11 sheets, 7 charts and 4 data. They are intermingled. Whenever I try to print the entire workbook, any data sheet after the first chart is blank. They view fine in print preview, but are blank when actually printed. Has anyone heard of this problem? I can print them one sheet at a time, but I am trying to pass the workbook on to my boss and I don't want him to have to hit print 11 times. We would also like to print to .pdf and don't want 11 files. I need help! LK |
#3
|
|||
|
|||
Well, unfortunately, I've tried that. The data sheets are always blank
when I print the whole workbook, no matter how I print them (whether I choose "Print entire workbook" or use the method you've described.) I'm just trying to figure out how to make the data sheets non-blank. Here's something that may help to clarify, though ... I discovered yesterday that the sheets only print as blank if there is a chart before them in the sheet order. If I move all the charts to the end of the workbook, the data sheets print fine. Unfortunately, we need them to be intermingled (for when we print to .pdf), so I'm still at a loss. Thanks for your help! LK "John Mansfield" wrote: Possibly this can help . . . Click once on the first tab of your workbook to activate it. Assuming it is called "Sheet1", the background of the Sheet1 tab should be white. Next, press the Shift key. Finally, go to the last tab in your workbook click on it. Now, all of you sheet tabs should be activated. If you print the workbook, all of the tabs should print as one job. You can save the workbook with all of the tabs activated too. Then, when your boss prints the workbook all of the sheets will print. ---- Regards, John Mansfield http://www.pdbook.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
charts lose data | Steve | Powerpoint | 0 | January 28th, 2005 06:13 PM |
Help with data not getting plotted | Scott Ehrlich | General Discussion | 2 | January 25th, 2005 05:17 AM |
Help - Linking sheets and data from Sheet 1 to blank worksheet | Bimmy | Worksheet Functions | 1 | March 11th, 2004 06:51 AM |
Chart Data Table, Data Range, etc. do not update on Chart | RichardS | Charts and Charting | 3 | December 17th, 2003 05:56 PM |