Excel Viewing Issue

[jade423]

An excel file saved by one user is displayed larger on another computer viewing the same file. When we change the zoom, it changes the size on all users, thus making it too small to view on others' computers. Any clue on how to change the view for all excel file on one specific computer? Original file saved on Excel 2003, trying to view gracefully on Excel 2007.

 

[Mike Blackman]

Hi Jade,

I think this all stems from the display resolutions set in windows, there is no way to ensure a workbook views the same on all computers, especially considering people have different size monitors.

 

[MPBJR]

I had the same problem and thanks to others from this site came up with a solution. Here is a link to the post.

http://www.mrexcel.com/forum/showthread.php?t=298093

 

[jade423]

That would sort of work, but would i have to put in that code every time i opend a new workbook, or if i did it in fileA.xls, would it also change for fileZ.xls???