"Margins Do Not Fit Page Size" error in Excel 2003?

Question

Has anybody come across this problem with Excel 2003 and found a suitable solution...?

I've got a standard Excel spreadsheet which I want to print to a Xerox colour printer. However, when I attempt to Print Preview the document, I get several errors saying "Margins Do Not Fit Page Size" and Excel then proceeds to split the spreadsheet up so that 1 cell is on each page, thus turning a 1 page document into a ~800 page one!! When sent to print, the printer also tries to print 800 pages.

I've tried adjusting the margins, and removing and reinstalling the print drivers but the problem persists. No other printers are installed. I've also tried clearing the Print Area, but for some reason when I adjust this, Excel splits the document up again (1 page per cell)!!

The document prints fine from another computer on the network so I think it's an Excel problem. There is an article on Microsoft's website, but it doesn't explain how to fix it.

Any help will be much appreciated. Thanks.

Answer 1

Lets do: Try these steps one after another

1- Open Excel with new file

2- Go to Page setup

3- Make sure you have A4 paper selected in paper size

4- Make sure margins are ok

5- close Excel

6- go to Control panel > Printers and faxes

7- Right click on Xerox printer icon and select properties

8- Make sure you have here the settings also to A4 as paper size and margins are all ok.

9- Now Try to open your file and go to View > Page break preview

10- Can you see there a good page breaks?

11- Try to print preview.

12- If you still facing thee same problem, lets do:

1- In your file, go to Page Setup

2- Make sure your are using a 100% scaling

3- If you still got the problem, We have to use violence with it.

Lets do

1- Copy each sheet into another one in another file by pressing

Ctrl+A then CTRL+C then CTRL+N then CTRL+Home then CTRL+V

for each sheet, save the new file and try printing again.



If you still got the problem I suggest to e-mail me.

Answer 2

I face the same problem ,now it s okay as default printer setting was wrong.

Answer 3

Restart your computer