Issue with Excel 2007 - Urgent

[Arlette]

I have a spreadsheet in Excel 2003 format which has some data and
charts in it. The data is obtained using links to various other
workbooks. I am able to see all data in 2003 format, however in excel
2007 format, i am not able to see the data. Is there some problem in
excel 2007 with regard to the links (formulae which links to other
workbooks)? Urgent, please help me at the earliest.

 

[Pete_UK]

Are your links referring to filename.xls, and you have renamed the
files to filename.xlsx?

Pete

 

[Arlette]

Its not me but another person who is actually using Excel 2007. Does
Excel 2007 automatically convert files with extension ".xls" to
".xlsx"? I asked the person concerned and they have all the files
with extensions as ".xls".

 

[Jim Rech]

This problem has been reported here before and not too long ago. I just
tried to reproduce it, starting with a simple link between files created in
Excel 2003 and, of course, I saw no problem when I opened them in Excel 2007
(with SP1).

So, any chance you can post (or email) a simple example?

--
Jim
| Its not me but another person who is actually using Excel 2007. Does
| Excel 2007 automatically convert files with extension ".xls" to
| ".xlsx"? I asked the person concerned and they have all the files
| with extensions as ".xls".

 

[Arlette]

Its actually company confidential information that i cannot share. I
have a question. If you have a workbook in 2003 format and you need
to open it in 2007 version, do you need to re-create the links?

 

[Jim Rech]

do you need to re-create the links?

No, the link was there and working fine when I opened the file in Excel
2007, which is certainly what you'd expect.

Of course, that's always the case. So maybe you could create a simple
example with new files, which should be easy in this case since the problem
is so pervasive at your company. Or if it's not so easy, take the real
files and clear away everything in both files except a few cells involved in
a problem link. Just so the end result has the problem. Might be good to
have such an example if you have to escalate this up to Microsoft in any
case.

--
Jim
|
| Its actually company confidential information that i cannot share. I
| have a question. If you have a workbook in 2003 format and you need
| to open it in 2007 version, do you need to re-create the links?