Kate has attended:
Excel Advanced course
Linked spreadsheets - inserting columns
Hi,
When I insert a column into a spreadsheet that is linked to another spreadsheet, the second one does not adjust its formulae to allow for the extra column. Is it possible to keep adding columns and have linked spreadsheet automatically adjust itself?
Thanks,
Kate
RE: Linked spreadsheets - inserting columns
Hi Kate
Thanks for your question.
I think it depends which version of Excel you are using - if you are using 2003 then formula results should automatically update themselves when extra columns or rows are inserted.
If the formulas are not automatically updating themselves then I'm afraid you might have to manually adjust the formulas yourself each time new columns are added in.
Amanda