I
Irvine, Dennis
I have an Excel 2007 spreadsheet with a Pivottable in it.
I want to give it to a person that has Excel 2003.
I have saved the spreadsheet in an Excel 2003 compatible file and given it
to the other person.
When they open it, it will not let them refresh the Pivottable when data is
changed.
the "Refresh" button is greyed out and we get a message about it being
created in a different version.
Is this a bug? Anyone have any suggestions or workarounds or words of
wisdom here.
Thanks for any help
Dennis
I want to give it to a person that has Excel 2003.
I have saved the spreadsheet in an Excel 2003 compatible file and given it
to the other person.
When they open it, it will not let them refresh the Pivottable when data is
changed.
the "Refresh" button is greyed out and we get a message about it being
created in a different version.
Is this a bug? Anyone have any suggestions or workarounds or words of
wisdom here.
Thanks for any help
Dennis