Conversion from Excel 2003 to Excel 2007 and links

[dkonings]

Hello,

I have a strange thing at hand. Today we moved from Office 2003 to Office 2007. After having opened an Excel 2003-file and saved it to an
Excel 2007 Macro enabled file (.xlsm) and re-opened the file I am getting the window that the source of a link cannot be found. If I open the 'old' (former Excel 2003) file then I am not asked what to do with the
links.

I am 100% sure that the workbook does not contain links. I have also reviewed the VBA-project, however wasn't able to find the filename the link (according to the links window) is referring to.

Can anyone advise ?

Regards,


Douwe

 

[Trevor G]

welcome to the Forum,

In 2007 look at the Data Tab when the workbook is open if you see the link Icon then you can click it to see what it says about links in the workbook

 

[dkonings]

Trevor G,

Thanks for the quick reply !!

I found the cause of this. What I did is the following :
Saved the workbook as a xlsx-file and see whether the error still occurred.
Yes it still occurred.
One by one deleted the worksheets and saved and re-opened the file.
This way I found the worksheet causing the error.
Then deleting groups of rows and saving the file.
This way I found the rows in which the error was.
Then deleting column by column, saving and re-operning to find out which column.
Then within the rows (found earlier) deleting row by row and voila ...
cause found.

This cell contains a list (Yes/No) and somehow these values were not put in in that list correctly. Some strange values were listed overthere.
From another simular Excel-file I have copied the cell into the xlsm-file and no alert anymore. Problem solved.

Regards,



Douwe

 

[Trevor G]

Pleased to read you resolved this.