Hello,
is it possible to limit refresh to only one sheet?
I want to build a template using input from Jet, but also enable users to input data on other sheets. Going into Design or Refresh mode would delete this data.
Is there a way to prevent this?
Date
Votes
2 comments
-
CascadiaDataworks Unfortunately, you can only refresh everything in a report. If you need persistent data, you can look into Stored User Data but it can get complex and add to run-times and file sizes.
That said, you can get creative with using things like VLOOKUPs on the report page and have another page for inputs. As long as there is no Jet functionality on a sheet, anything you add or remove on the non-Jet sheet will remain after a Refresh.
-
Mariya Budakova Hi Bryan,
thank you! This seems to work.
Please sign in to leave a comment.