Pivot Table connections with local cube (*.cub)

%3CLINGO-SUB%20id%3D%22lingo-sub-1254883%22%20slang%3D%22en-US%22%3EPivot%20Table%20connections%20with%20local%20cube%20(*.cub)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1254883%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20series%20of%20Pivot%20Tables%20connected%20to%20a%20local%20cube%2C%20this%20works%20fine.%20But%20when%20I%20try%20to%20change%20the%20source%20to%20a%20different%20cube%2C%20nothing%20changes%2C%20it%20reverses%20to%20its%20original%20settings.%20Who%20can%20help%20me%20with%20a%20%26nbsp%3Bworkaround%20or%20technical%20solution%2C%20I%20now%20have%20to%20rebuild%20all%20the%20pivot%20tables.%20I%E2%80%99m%20working%20in%20Excel%202016%20in%20a%20Citrix%20client.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1254883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a series of Pivot Tables connected to a local cube, this works fine. But when I try to change the source to a different cube, nothing changes, it reverses to its original settings. Who can help me with a  workaround or technical solution, I now have to rebuild all the pivot tables. I’m working in Excel 2016 in a Citrix client.

0 Replies