Kaso
New member
- Joined
- Apr 26, 2017
- Messages
- 24
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013, 2016, 365
Hey 
I am working with a merged table, but now i noticed that i am not able to see the changes on the data in Excel because i changed everything into intelligent tables to merge them and transform the data in PQ.
The thing is that i kinda need the function to see if some data was changed, so i started using a non intelligent table on one Excel file and get the data, make them a intelligent table and work with it on a second Excel file.
Problem with that again, is that this costs performance & i can only use an absolute path to get the data from the first file.
Does anyone happen to have an idea how to work with all that, so that i can use the function to see when some data got changed AND use the same data in PQ?
I am working with a merged table, but now i noticed that i am not able to see the changes on the data in Excel because i changed everything into intelligent tables to merge them and transform the data in PQ.
The thing is that i kinda need the function to see if some data was changed, so i started using a non intelligent table on one Excel file and get the data, make them a intelligent table and work with it on a second Excel file.
Problem with that again, is that this costs performance & i can only use an absolute path to get the data from the first file.
Does anyone happen to have an idea how to work with all that, so that i can use the function to see when some data got changed AND use the same data in PQ?