←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

External File-based Data Source Options for a PivotTable

What options are there to use as a data source for a Pivot Table?

Here are the criteria:

  1. Must be a file (or files) located on disk.
  2. When I press Refresh All, it should refresh all pivot tables from the datasource (which may have been changed entirely).
  3. I can define calculated fields in the datasource. (For fields that need to be summarized with a weighted-average).
  4. Fast, efficient. The datasource may have a hundreds of columns and hundreds of thousands of rows.
submitted by /u/Super-Program3925
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#financial modeling with spreadsheets
#cloud-based spreadsheet applications
#Pivot Table
#data source
#external file
#pivot tables
#data source options
#calculated fields
#Refresh All
#weighted-average
#disk