Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

MS Excel: Updating two spreadsheet simultaneously

SOLVED
Go to solution
Sanjay Verma
Super Advisor

MS Excel: Updating two spreadsheet simultaneously

Hi Friends,
I've two spreadsheet, a & b. I would like to associate both the spreadsheets together so that when I modify the contents of a, it should automatically update the contents of b (contents may include - values / formulas etc.). Any suggestions??
Co-operation - The biggest chain reaction
5 REPLIES
Roger Faucher
Honored Contributor
Solution

Re: MS Excel: Updating two spreadsheet simultaneously

Sanjay:

Open Excel Help and search for "Overview of linked and embedded objects". See if that answers your question.

Roger
Make a great day!

Roger
Jorge Pinto Leite
Respected Contributor

Re: MS Excel: Updating two spreadsheet simultaneously

The b excel file should have on the cells that should be updated a link to the a file, such as:
b file, cell A1:
= a!A5*300/a!a4
Note that you should put the full path to a file, and if it includes spaces you should put it inside commas, such as:
= 'c:\my documents\a'!A5*300/'c:\my documents\a'!a4
Jorge
Jorge Pinto Leite
Respected Contributor

Re: MS Excel: Updating two spreadsheet simultaneously

The b excel file should have on the cells that should be updated a link to the a file, such as:
b file, cell A1:
= a!A5*300/a!a4
Note that you should put the full path to a file, and if it includes spaces you should put it inside commas, such as:
= 'c:\my documents\a'!A5*300/'c:\my documents\a'!a4
Jorge
Jorge Pinto Leite
Respected Contributor

Re: MS Excel: Updating two spreadsheet simultaneously

Sorry to answer twice, but I had problems with my internet connection...
Jorge Pinto Leite
Respected Contributor

Re: MS Excel: Updating two spreadsheet simultaneously

Sorry to answer twice, but I had problems with my internet connection...