excel software training london - Linked spreadsheets - inserting columns

Resolved · Low Priority · Version Standard

Fri 16 Feb 2007, 12:27 Delegate Kate said...

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

Mon 19 Feb 2007, 13:46 Trainer Amanda said...

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

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

excel software training london - Linked spreadsheets - inserting columns

Linked spreadsheets - inserting columns

RE: Linked spreadsheets - inserting columns

Excel articles

Excel tip:

Do a fast scroll