View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Excel 97 - Excel 2003 Macros


You have checked the header/footer and top/bottom margin settings
to see if they are the same?

Are you absolutely sure that the row height for ALL rows is set to a specific size?
Setting all the rows to the "StandardHeight" will not guarantee cross version compatibility.
If the default font size in XL97 is different than that in XL2003 then the
default (standard) row height is probably different.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Robert Gile"
wrote in message
Assume you are talking about the size of a printed page...

Yes in print preview, 3 rows are moved to the next page making 8 total pages
rather than 6
Does everyone use the same printer?

Yes, you tried changing the printer to another brand/type, even a PDF
printer, no change
Does everyone use the same printer driver/version?

Yes, all pull from the server
Does everyone use the same font, font size and row height?

Yes, this all in the macros
Does everyone use the same monitor with identical settings?

No, I have some on 24", 19 and 20" LCDs and one on CRT. The CRT user and
another LCD user are working. But screen resolution shouldn't affect this,
right? I means its more pointing to a size calculation difference.

When I hold the correct and incorrect printouts side by side, the incorrect
page's cells appear to be larger, even though this is set in the macros. Also
note that all users on Excel 2003, same patch level [WSUS every night] and
that when I install Excel 97, the spreadsheets preveiw correctly on a
computer that previews them incorrectly in Excel 2003.