I have a main source sheet that I have linked to other sheets (the same info,
only broken down by city). When I add a row to the main page, it doesn't
update the linked pages. It updates the cells that were already there, but
won't insert new rows when I do on the source sheet. I'd appreciate any
help. Thanks!

I'd be happy to remote into your machine via GotoAssist.com and take a look.
--
http://HelpExcel.com




"WorkingGirl4774" wrote:

I have a main source sheet that I have linked to other sheets (the same info,
only broken down by city). When I add a row to the main page, it doesn't
update the linked pages. It updates the cells that were already there, but
won't insert new rows when I do on the source sheet. I'd appreciate any
help. Thanks!

Hi,

Excel never put formula in cell just because. If you want to do this you
can consider 1. Putting formulas in place which are "ready" for new data, 2.
Write VBA code to respond to a change event in the source sheet.

For example if your current linked formulas read

=Sheet1!A1
you could change it to read

=IF(Sheet1!A1="","",Sheet1!A1)

You can copy this type of formula anywhere in the target sheet and it will
be ready for new rows of data and it won't show anything until those source
cells are populated.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"WorkingGirl4774" wrote:

I have a main source sheet that I have linked to other sheets (the same info,
only broken down by city). When I add a row to the main page, it doesn't
update the linked pages. It updates the cells that were already there, but
won't insert new rows when I do on the source sheet. I'd appreciate any
help. Thanks!