Identify Changes After Refreshing Data in Excel Workbook

Question

Hello to everyone.

I have an excel file where i am downloading a view of a database. 

I need to download data very often.

There is any way or any approach of how to identify what tables have been change after the refresh regarding the previous status,

or which lines of the table have been changed after the refresh?

I assume that the way has to do with the VBA help, but i need also an approach.

For  example i have 10 sheets with one table per sheet. (So 10 tables).

When i am refreshing the excel file all sheets i assume that there are some changes on 6 tables.  Or in 5 lines in one table.

How ca i identify those changes. I need an alert that sheets 1,4,6,7,8 have changed.

Or an alert that line 3,5,9 of a table 1 - sheet 1 have changed.

Thanks in advance for your valuable time,

Manos

Answer 1

How about using the "Track Changes" facility on the Review tab of the Ribbon.  You would need to activate it before the Refresh.

Answer 2

Thank you very much for quick response.

I have consider this solution, but there are two issues here.

It turns the file shared so, it creates an issue that another user may open the file, which i do not want.

Also i do not have a clear icon of two tables and the differences, that come up from the refresh.

I was consider and option of copy the table before the refresh and then highlight the change in the main table with the differences.