53 - Print a table, then load it
Sometimes you have a table that's slow to update, and doesn't require frequent updates. This can be a table of employees or the items you sell.
You can instead have one query that physically prints the output of the table, then have your other queries reference the physical table rather than the query itself.
Also remember to remove the first query from "Update All".
To be extra user-friendly, you can add a macro to specifically update your queries.
00:00 Intro
00:23 Remove from RefreshAll
00:43 Use the physical output table
01:57 Adding a step before Source
02:57 Adding Update-macros
04:49 Testing functionality
Watch video 53 - Print a table, then load it online without registration, duration hours minute second in high quality. This video was added by user WesleySon 18 December 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 87 once and liked it 2 people.