Linking Excel Spreadsheets

[Zonie32]

I have 2 separate Excel Spreadsheets on a server. Each spreadsheet is updated by separate departments.

I combined the 2 spreadsheets into one and put it on the server but was told I couldn't use the combined spreadsheet because it wouldn't be updated.

Is there a way to link my combined spreadsheet to receive the individual updates?

 

[xlbo]

Have a look into SHARING the workbook

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Zonie32]

Thanks for your response.

The combined spreadsheet that I developed is a shared document but I was told by the owners of the 2 separate spreadsheets that because my document was combined, the updates made in the individual list would be update my document.

Am I missing something???

 

[xlbo]

Apologies - I initially thought you meant that you had replaced the individual spreadsheets with the new combined one but, if the spreadheet is shared, they should be updating that, not the individual ones...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question