Operating System - Microsoft
1748171 Members
4170 Online
108758 Solutions
New Discussion юеВ

Re: 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 5
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...