rhinohelix

Is this what I am looking for as to why it displays in 2002 and doesn't display anything in the later versions, specifically 2003? What changed between versions that would cause it not to display? Was there something the way 2002 and 2003 displays the errors, etc.? Other than changes to the Analysis Tool Pack to some of the functions, I can't find any changes between the versions that would cause this. In the 2002 version, a number is displayed there, which allows the rest of the form to be populated, as the other formula and cells draw off it. In the 2003 version, nothing is displayed there, which messes up the rest of the spreadsheet. My quandry is what would the difference be, and how can we get the 2003 version to get the same results as 2002? Right now there are members of this group demanding to be rolled back to 2002, which is something I am desperately trying to avoid. Sorry for the vagueness of my post and TIA for your assistance.

At my company we recently began converting from Office 2002/XP to Office 2003. An issue has arisen where a spreadsheet involving pivots tables will display results in 2002 but are empty when viewed in Excel 2003 or 2007. Here is the formula in question: I don't post it to figure out if there is something wrong with it, as none of the Excel versions have an issue with the formula but to determine why of the 3 machines I have in front of me only the one with Excel 2002 displays the results while the ones with Excel 2003 and 2007 don't. Any help, even a hint of the direction in which to look would be appreciated.