Hi there,
I have been using the get and transform function in excel for a while.
I have a workbook with a lot of individual reports. I have connected them using get and transform, but when I replaced the data with current month's data, for some reason my merged table that is connected to all other tables / spreadsheets is not refreshing. I have tried refreshing in the connection / query edit as well as at the front end.
Any ideas?
I did notice that 3 of the spreadsheets say 'there are no data sources for this query' but the rest of them all display the workbook's name.
Thank you
Figen
I have been using the get and transform function in excel for a while.
I have a workbook with a lot of individual reports. I have connected them using get and transform, but when I replaced the data with current month's data, for some reason my merged table that is connected to all other tables / spreadsheets is not refreshing. I have tried refreshing in the connection / query edit as well as at the front end.
Any ideas?
I did notice that 3 of the spreadsheets say 'there are no data sources for this query' but the rest of them all display the workbook's name.
Thank you
Figen