Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Excel spreadsheets linked together

I have a specific quarterly report (B) that is linked to the information
contained in the original monthly financial document (A) ... the Document A
has numerous "extra" rows in it ... if I delete the extra rows, essentially
making all of the tabbed worksheets in Document A the same (which will make
it easier for me to update quarterly in Document B), will the links in
Document B change accordingly with the changes made in Document A or will I
need to re-do all of the links in Document B after I make the changes to
Document A? I know this is confusing ...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 459
Default Excel spreadsheets linked together

CLH929 wrote:
I have a specific quarterly report (B) that is linked to the
information contained in the original monthly financial document (A)
... the Document A has numerous "extra" rows in it ... if I delete
the extra rows, essentially making all of the tabbed worksheets in
Document A the same (which will make it easier for me to update
quarterly in Document B), will the links in Document B change
accordingly with the changes made in Document A or will I need to
re-do all of the links in Document B after I make the changes to
Document A? I know this is confusing ...



It depends on how the two files are linked together...
If they are linked by absolute references, deleting some rows from the
master document (your A document) will not influence the linked file (your B
document). Anyway, it is better delete the rows with both files opened and
then save both.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Hyperlinking to Excel 2000 with a linked spreadsheet LDPitsy1970 Excel Discussion (Misc queries) 0 October 12th 05 02:31 PM
How do I automatically open linked documents in Excel? DroKoz New Users to Excel 3 June 28th 05 03:25 PM
Linked Excel Spreadsheets MAB Excel Discussion (Misc queries) 0 March 24th 05 02:51 PM


All times are GMT +1. The time now is 08:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"