I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.

I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.

It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find that the Print Area is different. It seems to
have made the print area smaller so what was on the bottom of one page
in Excel 2000/2002 is now on the top of the following page.

It only does this in Excel 2003. If I load the exact same file back
into Excel 2000/2002 the Print Area is fine once again.

Does anyone know why this is happening? Is there an issue with the Set
Print Area feature in Excel 2003? It would appear that it determines
the print area differently.

How can I get around this? I don't want to have to change the actual
layout of the report since the spreadsheet needs to be usable in all
versions of Excel, not just 2003. So changing the actual layout isn't
really an option.

Thanks
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=470104

Rob,

Have you checked the margin settings?

Jim Cone
San Francisco, USA


"TheRobsterUK"
wrote in message
news:TheRobsterUK.1vshic_1127441104.4321@excelforu m-nospam.com
I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.
I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.
It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find that the Print Area is different. It seems to
have made the print area smaller so what was on the bottom of one page
in Excel 2000/2002 is now on the top of the following page.
It only does this in Excel 2003. If I load the exact same file back
into Excel 2000/2002 the Print Area is fine once again.
Does anyone know why this is happening? Is there an issue with the Set
Print Area feature in Excel 2003? It would appear that it determines
the print area differently.
How can I get around this? I don't want to have to change the actual
layout of the report since the spreadsheet needs to be usable in all
versions of Excel, not just 2003. So changing the actual layout isn't
really an option.
Thanks
-Rob

Yes the print margins are fine.

I don't understand why the formatting is fine in Excel 2000/2002 but
different in Excel 2003. I thought all settings were supposed to be
maintanined between all versions of Excel?

-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=470104