Excel Viewing Issue

jade423

New Member
Joined
May 29, 2008
Messages
26
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

Well-known Member
Joined
Jun 8, 2007
Messages
2,494
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

Board Regular
Joined
Mar 28, 2007
Messages
136
I had the same problem and thanks to others from this site came up with a solution. Here is a link to the post.
HTML:
http://www.mrexcel.com/forum/showthread.php?t=298093
 

jade423

New Member
Joined
May 29, 2008
Messages
26
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???
 

Forum statistics

Threads
1,081,530
Messages
5,359,353
Members
400,524
Latest member
Excelbat

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top