Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-04-2023, 07:12 AM
DBenz DBenz is offline Open second instance of a workbook 2010 as read only method fails for 2013 Windows 7 64bit Open second instance of a workbook 2010 as read only method fails for 2013 Office 2010 32bit
Advanced Beginner
Open second instance of a workbook 2010 as read only method fails for 2013
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default Open second instance of a workbook 2010 as read only method fails for 2013

Hi,
in Excel 2010 , if I launch my finances workbook from desktop shortcut and it appears on screen I get hold of it at top and drag bang it against RHS screen edge and it occupies RHS half of screen.


I then would go to the desktop shortcut for excel itself and launch another instance of excel, then open that excel file by selecting it from recent files list it shows, it says already open so it will be 'read only' and I accept that 'read only' and bang it against left side of screen, I now have my file visible twice, read only at left and editable at right.


Now I can copy data and formats from one page at left to another at right dead easy. I can view one page alongside another dead easy. Look for Tesco food Current ac at left and copy paste it into spending sheet at right etc !



When I do this now in Excel 2013 windows 10 that method fails, the one at left is a blank new sheet new file.

if I launch Excel from desktop shortcut and bang it against lhs screen then browse to the file (I already have open at rhs) it opens the file but reopens in fact the one at rhs, when I bang that at right, the left half is an empty excel file again.

Basically it refuses to open a read only file version of the one already open.

How do I solve this problem ?

is this windows 10 or a change in design of Excel ?

Cheers


DBenz
Reply With Quote
 

Tags
read only



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2010 Excel attachments from mail open in Read Only mode remi Outlook 0 08-09-2016 06:50 AM
Open second instance of a workbook 2010 as read only method fails for 2013 Autofill SaveAs File Name box using read only workbook newbieX Excel Programming 1 05-20-2015 11:16 PM
Can't open 2010 ics calendar file in 2013 JuanMunito Outlook 0 12-02-2014 09:06 AM
ThisAddIn.Application.Documents.Open() methods opens new word instance even though the active docume chetan rajakumar Word VBA 1 08-23-2014 03:52 AM
Open new instance for each file a3ng25 Office 1 01-28-2013 06:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft