Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 09, 06:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default Excel 2007 spreadsheet references older office spreadsheets

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?

  #2   Report Post  
Old May 6th 09, 04:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?

  #3   Report Post  
Old June 29th 09, 02:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default Excel 2007 spreadsheet references older office spreadsheets

I am having similar problems since my company is converting. The problem as
I understand it is that when you open a 2003 spreadsheet with 2007, it auto
converts it to 2007 and breaks any links to any other 2003 spreadsheets. The
only way for it not to break the links (that I have been told by the IT
department) is to have all of my spreadsheets open that are linked. This is
impractical due to the sheer number of spreadsheets involved. Anyone found a
way around this?

Thanks

"JR Hester" wrote:

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 vs. Older Views? manycowsrick Excel Discussion (Misc queries) 2 February 19th 09 01:41 PM
Office 2007 install corrupted excel spreadsheets? fox_mulder33[_2_] Setting up and Configuration of Excel 0 January 24th 08 03:57 PM
How do I track changes on an Office 2007 Excel spreadsheet Jeff K Excel Discussion (Misc queries) 2 August 23rd 07 04:22 AM
How do I track changes on an Office 2007 Excel spreadsheet Jeff K Excel Discussion (Misc queries) 0 August 22nd 07 09:46 PM
Sharig spreadsheet with older version of MS EXCEL (2000) Peter KNAP Excel Discussion (Misc queries) 0 February 16th 07 01:40 PM


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017