Problem with Excel links

  [DELETED] 22:45 21 Aug 2003

I have a number of Excel spreadsheets saved as separate files and I wish to link them to a single summary sheet. Linking them isn't a problem, however I would like to be able to 'switch off' the links to particular
files so that I could select which files were included on the summary sheet at any one time.

I would appreciate any suggestions.


  [DELETED] 22:54 21 Aug 2003

I also have several excel sheets linked to a summary, but I haven't had occasion to "switch off" any of them. Let me work on it and I will post back to you. May take a bit of time.

  Macaonasa 23:25 21 Aug 2003

Have you tried Edit/Links?

  [DELETED] 23:37 21 Aug 2003

"Update only some of the links to other workbooks

Close all workbooks.

Open the workbook that contains the links.

When asked whether to update links, click Don't Update.

On the Edit menu, click Links.

In the Source list, click the linked object you want to update.

To select multiple linked objects, hold down CTRL and click each linked object.

To select all linked objects, press CTRL+A."

From the Excel Help file

  [DELETED] 10:05 22 Aug 2003

Thanks to everyone for your response so far. I will give your suggestions a go.

  [DELETED] 17:26 22 Aug 2003

I think I might have got this wrong Guys. My "links" to the summary are all formulae. Is that different from a link?

  [DELETED] 20:18 22 Aug 2003

My understanding is that if the formulae refer to cells, names, ranges etc. in another spreadsheet or spreadsheet file, then they are links.

I'm not sure if I've explained the problem very well. I want to have all the linked spreadsheets populated with data and then to be able to select which spreadsheets 'feed' through to the summary sheet to look at different scenarios. Maybe I'm approaching things the wrong way.
I could open all the spreadsheets, clear the data from the spreadsheet/s that I wish to ignore and then update the links. This would be a little fiddly though, and there would be a danger that the cleared spreadsheet could be inadvertantly saved.

  [DELETED] 20:28 22 Aug 2003

Why not just set up multiple worksheets on the 'master' spreadsheet (the one that displays the linked information)?

Each sheet show a different scenario - Sheet1 shows the values from workbooks A, B & C, Sheet 2 shows the values from workbooks B, E & F, and so on.

Or have I misunderstood?

If your problem is more complex than this, go to Help (within Excel), and lookup 'scenario'. It is a more complicated way of achieving what you seem to want, but it will certainly work.

  [DELETED] 20:44 22 Aug 2003

Thanks jazzypop. I wouldn't fancy doing that with lots of sheets but in this instance I think it might be the simplest solution.

I did have a quick look at scenarios but it looked a bit complicated. I might look into this when I've got a bit more time.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Illustrator Amy Grimes on how setting up her own eco-brand led to success with clients too

MacBook Pro keyboard issues and other problems

Test : l’enceinte connectée HomePod d’Apple