Problem with Excel Links

[John]

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

Put another way, I want to have all the linked workbooks populated
with data and then to be able to select which worksheets 'feed'
through to the summary sheet to explore different scenarios.

Any help will be very much appreciated.

John

 

[Rafael Ortiz]

You can use Edit, Links and change your source there....

MRO

 

[John]

Rafael

Thanks for your reply. I realise I might not have been clear with my
question.
I knew that I could 'edit links' but I wanted to be able to change
sources quickly without having to change all references each time.

John