J
J Austin
I have a spreadsheet linked to an Access table whose values changes weekly.
When I do a "Refresh All", the Excel spreadsheet updates correctly. I have a
PT derived from the spreadsheet that does not update unless I have that PT
selected and use the "Refresh" command (e.g., the "Refresh All" does not seem
to apply to the entire workbook). However, a detail sheet derived from the
updated PT does not update. Is this how the system operates, (e.g., must
create a new detail sheet manually after an update to the PT source?).
Thanks in advance,
J Austin
When I do a "Refresh All", the Excel spreadsheet updates correctly. I have a
PT derived from the spreadsheet that does not update unless I have that PT
selected and use the "Refresh" command (e.g., the "Refresh All" does not seem
to apply to the entire workbook). However, a detail sheet derived from the
updated PT does not update. Is this how the system operates, (e.g., must
create a new detail sheet manually after an update to the PT source?).
Thanks in advance,
J Austin