ODBC with Excel Pivot Tables

Legacy Contributor

Has anyone had experience using pivot tables in Excel using a ProvideX ODBC connection? It is a new feature in Office 2010 that allows you to filter a range of data in Facts or whatever application, but in this case it is Facts. I have asked Infor Support if they could tell me yes or no as to if it works. All they said is it should and they dont use excel. Any help is greatly appreciated. Happy new year.

Thanks
Joel

Cheng Ruan

Hi Joel,

Actually, pivot tables have been available with Excel for some time. What is new is a wizard that automatically converts data more quickly into a pivot table. I've used them with FACTS for many years. Your spreadsheet stores the underlying MS Query criteria for accessing the ODBC source and allows you to refresh the data and recalculate the pivot table so long as you still have connectivity with FACTS.

Ralph