Welcome to my first 2020 #TipTuesday post. Today’s topic is Excel and how a background refresh setting can impact refreshing pivot tables.
The background to this post is related to a report I was creating for a client to validate timesheets prior to approval. The report has a couple of queries in them (from SQL) and a pivot table to summarize the data. In order to make the refreshing…
Continue Reading Jen Kuntz’s Article on their blog
Excel Background Refresh & Pivot Tables
Welcome to my first 2020 #TipTuesday post. Today’s topic is Excel and how a background refresh setting can impact refreshing pivot tables. The background to this post is related to a report I was creating for a client to validate timesheets prior to approval.
Blog Syndicated with Jen Kuntz’s Permission
More About This Author
- Jen is a self-employed Dynamics GP consultant, based in Southwestern Ontario, Canada. She is a Microsoft MVP in Business Applications (since 2016), a GPUG All-Star and a designated accountant (CPA, CGA).
Array
Dyn365GP25 September 2024Dynamics GP End of Life announcement
Dyn365GP24 September 2024MVP Renewal for 2024/2025
Dyn365GP30 March 2024Planes, Trains & Automobiles!- Dyn365GP26 March 2024Decimal Places for HR Benefits
