View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default Excel 2007 spreadsheet references older office spreadsheets

Check with your coworker and confirm and that the "master" spreadsheet and
the "linked" sporeadsheets are still in the same locations as before. I have
a set of old Excel 97 linked sheets an dthey work just fine, as long as they
stay in their original folder locations. But is one gets moved to a new
location the linked formulas all have to be relinked to the new location.

HTH

"NuclearNed" wrote:

I'm relaying this message on behalf of someone else, so I hope I get the
details right...

My company recently upgraded to Office 2007. One employee has an Excel 2003
spreadsheet which references formulas in a large number of other Excel 2003
spreadsheets. When she opens the "master" spreadsheet in Excel 2007,
apparently the references are broken. Is there any way to preserve these
references, short of converting all the spreadsheets to 2007?