stuartmacdonald
New Member
- Joined
- May 26, 2009
- Messages
- 48
I have a series of named tables in a workbook - Planner.xls - saved on OneDrive.
I then have a workbook - Timesheet.xls - saved on OneDrive, which uses a power query to draw data from the named tables in Planner.xls, saving this in named tables within Timesheet.xls.
The query itself updates to reflect any changes in Planner.xls and this can be seen in the preview (or peek), but the named table does not update.
You can see in this screenshot that the preview (or peek) shows the query, and it has 4 contracts listed e.g CS-15-19 Islington Council etc....
But in the table in the workbook, its still listing 7 contracts.... Its this table that does not update.
https://www.dropbox.com/s/dk2bpxx2zh...E.g.1.png?dl=0
Any ideas?
I then have a workbook - Timesheet.xls - saved on OneDrive, which uses a power query to draw data from the named tables in Planner.xls, saving this in named tables within Timesheet.xls.
The query itself updates to reflect any changes in Planner.xls and this can be seen in the preview (or peek), but the named table does not update.
You can see in this screenshot that the preview (or peek) shows the query, and it has 4 contracts listed e.g CS-15-19 Islington Council etc....
But in the table in the workbook, its still listing 7 contracts.... Its this table that does not update.
https://www.dropbox.com/s/dk2bpxx2zh...E.g.1.png?dl=0
Any ideas?
