Excel changed in 2013 from SDI to MDI (single/multiple document interface).

May I ask why you need a second read-only copy specifically rather than just opening a new window on the same workbook?

Hi,
I dont mind what method I use as long as left half of screen I can go to any page (sheet) in my workbook and in right half of screen is my workbook fully functional and able to be typed into, have colours changed, be pastef to from that at left etc.



How do I then manage this as it seems you have another way I wasnt aware of. I just found that by opening the workbook again using the excel prog via its shortcut on the desktop and choosing the file I already have open it opened it again as read only, allowing me to go through the sheets.


Please talk me through the steps involved to achieve this.


Cheers


DBenz