 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Issue with Excel 2007 - Urgent
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. Are your links referring to filename.xls, and you have renamed the files to filename.xlsx? Pete > 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. 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". 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?  SignatureJim | 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". 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? >>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. >>Its actually company confidential information 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. SignatureJim | | 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.