topic Re: MS Excel: Updating two spreadsheet simultaneously in Operating System - Microsoft

MS Excel: Updating two spreadsheet simultaneously

Sanjay Verma — Wed, 07 May 2003 00:08:34 GMT

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??

Re: MS Excel: Updating two spreadsheet simultaneously

Roger Faucher — Wed, 07 May 2003 01:23:10 GMT

Sanjay:

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

Roger

Re: MS Excel: Updating two spreadsheet simultaneously

Jorge Pinto Leite — Thu, 08 May 2003 13:32:10 GMT

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

Re: MS Excel: Updating two spreadsheet simultaneously

Jorge Pinto Leite — Thu, 08 May 2003 13:32:59 GMT

Re: MS Excel: Updating two spreadsheet simultaneously

Jorge Pinto Leite — Thu, 08 May 2003 13:35:58 GMT

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

Re: MS Excel: Updating two spreadsheet simultaneously

Jorge Pinto Leite — Thu, 08 May 2003 13:36:14 GMT

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