Table question!!

[bln19]

I want to reference a table (not a pivot table) from another Excel file. I want it to update automatically if the original table is changed in any way. Any ideas?

 

[texasalynn]

so I take that your "table" is just a range of cells?

 

[bln19]

Well, it's "formatted as a table" and I want to copy it over to another file and have it automatically update.

 

[bln19]

Thank you for your time, but I actually answered my own question.