PC Review


Reply
Thread Tools Rate Thread

different margins in excel 2000 and 2002

 
 
Albert Moran
Guest
Posts: n/a
 
      27th Aug 2004
I have books created with excel 2000 with a certain format (in this case,
the sheet margins). When I open this files with excel 2002, the margins are
different from the original ones.
Opening the same file (without changing nor saving) with excel 2000 and
excel 2002 I see different margins.
Anyone know the cause? Any way of maintain the original format when working
in excel 2002? I have lots of work files, and change the format individually
is not a desirable option.

Help would be appreciated. Thanks,

Albert


 
Reply With Quote
 
 
 
 
David McRitchie
Guest
Posts: n/a
 
      27th Aug 2004
Hi Albert,
Whenever you switch to a different printer, get an update, get a new
version of Excel you may be using a different print driver. Usually
the changes are not noticeable unless you are relying on the output
to look exactly the same and break (page breaks) in the same place
throughout it's use. You may get some satisfaction by using
page setup and changing pages wide and / or pages tall to a
specific number for that worksheet.

If you must produce a report to print the same on any printer, then
you might want to print to a PDF logical printer, save the file, and
distribute the PDF file. More information
http://www.mvps.org/dmcritchie/excel/pdf.htm

You might also double check your printer set up, outside of Excel
buy addressable from Page Setup, General, options. Make sure
you have 8 1/2 x 11 paper in US or A2 paper in Europe.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Albert Moran" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I have books created with excel 2000 with a certain format (in this case,
> the sheet margins). When I open this files with excel 2002, the margins are
> different from the original ones.
> Opening the same file (without changing nor saving) with excel 2000 and
> excel 2002 I see different margins.
> Anyone know the cause? Any way of maintain the original format when working
> in excel 2002? I have lots of work files, and change the format individually
> is not a desirable option.
>
> Help would be appreciated. Thanks,
>
> Albert
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: "Margins do not fit page size" error in Excel 2002 Jacobscout Microsoft Excel Crashes 0 7th Dec 2007 04:27 PM
RE: "Margins do not fit page size" error in Excel 2002 =?Utf-8?B?QnViYmFGcmFua3M=?= Microsoft Excel Crashes 2 14th Mar 2007 06:10 PM
Margins in Excel 2000 =?Utf-8?B?QXQgSG9tZQ==?= Microsoft Excel Misc 2 25th Aug 2006 08:32 PM
Excel 2000 VBA App Now Works in Excel 2003, but not Excel 2002 bobkaku Microsoft Excel Programming 0 11th Mar 2005 02:07 AM
Importing Access 2000 into 2002 print margins problem Graham Microsoft Access Reports 0 8th Jul 2003 08:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:01 PM.