Select the first sheet tab, then with the SHIFT key depressed select the last
sheet tab. You will notice that the file name will change to GROUPED.

Inserting a row on a sheet will ensure that the row is inserted in all the
selected row.

PLEASE ENSURE that you ungroup the sheets (right click on the tab name and
then select ungroup) as soon as possible because in a grouped format ANYTHING
you do will affect ALL sheets (even if you delete).

HTH

"ndpocohantas" wrote:

I have 5 workbooks that link to one workbook. If I need to add a row how do
I do that in all workbooks at one time?