Forum Discussion
cassidy
Power Participant
Power ParticipantExcel Version 2311
For those of you who use BI via connected PivotTables, the latest Excel version of 2311 is preventing both refreshes of existing connections as well as creating new connections. Please vote for t...
GilbertQ
Super User
Super UserHi cassidy
As a workaround what happens if you create the pivot table in Excel online and then open it in the Desktop App, that MIGHt work?
cassidyPower Participant
Power ParticipantGilbertQ , yes that does work and I've instructed users to do so as a solution. We also have at least have of users on the older version, so people are literally using their neighbor to refresh a workbook for them.
Excel updates break BI functionality far too often, it'd be real nice if they included it in their testing.