Brad

If you save the file as XL97-2003 format this will happen if you have used
any of the new PT features of XL2007, you should get the compatibility
feature though. Is this a native xlsx or an old xls?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"brad" wrote in message
...
Occassionally when I save and close a file, all of the pivot tables get
range
valued and cannot be modified anymore when I reopen a file. I only
started
getting this problem when I switched over to Excel 2007. Anybody know
what
is going on?