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
A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.
Blog Syndicated with Jen Kuntz’s Permission