If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked cells in read-only mode
Victoria wrote:
If the source sheet is then revised, must I close and re-open the target sheet (which I need to open in read-only mode) to get the updates? Is there a way to do this with the sheet open in read-only mode? If the source sheet is revised in the same instance of Excel then you should see the updates in the target sheet. If it is revised in a different instance of Excel you can go to Edit / Links / Update Now rather than closing and re-opening. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking cells to MS Project cells | Bob | General Discussion | 0 | July 26th, 2004 05:51 PM |
linked cells | tom in chats | Worksheet Functions | 3 | July 12th, 2004 09:24 PM |
Links to other excel file - I can't find the cells with the links! | Samir Kapadia | Worksheet Functions | 1 | June 8th, 2004 07:51 AM |
Office XP | Ed Lester | Setup, Installing & Configuration | 1 | May 27th, 2004 09:30 AM |
Formatting cells to read time in 1/100ths | John Wright | Setting up and Configuration | 1 | March 9th, 2004 11:38 PM |