Linked Files (Excel 2000)

Topic

New Reply

I have two excel files. Each cell in the second file is linked to the first by “=(filename.xls)Sheet1!A1)”, etc., I also have autofilter set to only view an “active” column on file 2.
When I add a new row with “active” status to file1, file2 does not update until I select the filter again.

Is there a way to have the second file automatically update when a new “active” row is added to the first excel file?

Thank you.

Reply | Quote

Replies

You could add code to worksheet activate event to filter on the appropriate column.

So when you leave file 2 and change file1 status, then goto file 2, the macro would trigger (file2 is activated) and the column would be filtered

Private Sub Worksheet_Activate()
    Range("A1").AutoFilter Field:=1, Criteria1:="active"
End Sub

Change the range, field number and criteria as appropriate.

Steve

Reply | Quote

You could add code to worksheet activate event to filter on the appropriate column.

So when you leave file 2 and change file1 status, then goto file 2, the macro would trigger (file2 is activated) and the column would be filtered

Private Sub Worksheet_Activate()
    Range("A1").AutoFilter Field:=1, Criteria1:="active"
End Sub

Change the range, field number and criteria as appropriate.

Steve

Reply | Quote