![]() That is, it only can return the numbers and text you see on your screen. That limits your power, because GETPIVOTDATA works like a “screen-scraper” function. If you don’t set up your Pivot Table as a database, you typically must use the GETPIVOTDATA function to return data from it. I’ve never seen a description of how to use Pivot Tables as a database that works much like an Excel Table. That’s too bad, because PivotTable databases can give your formulas access to a massive amount of data. Two Functions You MUST Know to Return Values from Excel Tables.Here are the other articles in this series: ![]() In this third article in a series about using EFDs, we move from Excel strategies to Excel hands-on. You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs).
0 Comments
Leave a Reply. |