J
Jayde88
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
In my Excel 97-2004 files - I have some pivot tables. I also have a Summary Sheet that I link to certain cells within the pivot Tables. In Windows - I never had any problems - I would refresh the data and the links would stay. In Mac 2004 - as soon as I opened the file - all the 'GETPIVOTDATA' references had errors or #VALUE. Thus I changed them all by reselecting the cells, noticing that the formula changed to a simple +SHEETNAMEcellnumber format (example - +PivotA4). Thus when I refresh the pivot table - all the cells are now referenced purely by the cell number and don't link to the proper cells anymore. Is there anyway to fix this so that it has the same functionality from Windows as well as Mac version of Excel?
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
In my Excel 97-2004 files - I have some pivot tables. I also have a Summary Sheet that I link to certain cells within the pivot Tables. In Windows - I never had any problems - I would refresh the data and the links would stay. In Mac 2004 - as soon as I opened the file - all the 'GETPIVOTDATA' references had errors or #VALUE. Thus I changed them all by reselecting the cells, noticing that the formula changed to a simple +SHEETNAMEcellnumber format (example - +PivotA4). Thus when I refresh the pivot table - all the cells are now referenced purely by the cell number and don't link to the proper cells anymore. Is there anyway to fix this so that it has the same functionality from Windows as well as Mac version of Excel?