In excel can you write a report of more than 40 pages?

Brent pigeon | 12:20 Thu 10th Mar 2011 | Technology

4 Answers

I am unable to print a report that runs to more than 40 pages. Everyting beyond the 40th page has a grey background on the wcreen and will not print.

Phone to PC

java

Answers

1 to 4 of 4

Best Answer

No best answer has yet been selected by Brent pigeon. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

MarkRae

This is unlikely to be Excel's fault. What printer do you have? It sounds very much like it's running out of memory. Either that, or the driver is corrupt...

Brent pigeon

Question Author

It still stores the data but, as mentioned, everything added is on a grey background on any computer and will not print. I have seen longer docs that are not grey after a few pages like mine. I think it must be the settings.

rojash

Have you set a Print Area, perhaps? If so, anything outside the area will not be printed.
You don't mention which version of Excel, but in 2007:
Page Layout
Print Area
Clear Print Area

MarkRae

Indeed. I have printed much larger areas than this...

1 to 4 of 4

Do you know the answer?