Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
How do I automatically open linked documents in Excel? | New Users to Excel | |||
Linked Excel Spreadsheets | Excel Discussion (Misc queries) |