31st July 00:42
Pivot table stops working due to versioning
I am using a pivot table within IE. This works (Worked) fine on my
machine and my test machine.
Since installing .net on my machine, the thing behaves differantly.
Queries that I saved (XML Data) prior to .net do not load anymore.
Error is "The pivot table "sales" could not connect to the datasource
"sales". Now I can open the cube with Proclarity and query it fine.
Nothing wrong with the cube.
If I try open the cube with the pivot table, it's fine. I can query it.
Save the XML and reopen the query, same error as above. The XML is not
Another issue I have is have is that cubes are available from my
machine but other's refuse to open them. When I see the About on the
machines, the version is identical. 126.96.36.19930 SR-1.
Am I missing somthing or are there differances between the versions.
Maybe due to windows updates, .net etc etc?
My problem is many people are going to be using this and I have little
control over what version of office they use. Can only specify >= 2000