D
dsanita
Hi all:
I have been trying to prepare a report that works dynamically as if I
were to pull data from an external source. ie: If I write some SQL
code through MS Query and pull data into excel, it will automatically
insert/remove rows from the previous refresh, as well as to calculate
adjacent columns.
Is there a way to do the exact same thing using internal data?
BTW, I tried doing this by using the "get external data"... It work,
BUT, I am not able to transport the file to any other location without
serious consequences, and it takes much longer to refresh.
Thanks for your help,
Don
I have been trying to prepare a report that works dynamically as if I
were to pull data from an external source. ie: If I write some SQL
code through MS Query and pull data into excel, it will automatically
insert/remove rows from the previous refresh, as well as to calculate
adjacent columns.
Is there a way to do the exact same thing using internal data?
BTW, I tried doing this by using the "get external data"... It work,
BUT, I am not able to transport the file to any other location without
serious consequences, and it takes much longer to refresh.
Thanks for your help,
Don