Hi,
I have two excel workbooks, one created in excel 2003 and the other using excel 2007. When i link a cell from the excel 2007 workbook to a cell in excel 2003 workbook (that has some text in it), it shows a "#N/A" message. However if i then open the excel 2003 workbook using excel 2007 (keeping the excel 2007 workbook open), the error vanishes.
In other words i need to open and close the excel 2003 workbook to have the link work correctly.
This issue can be also reproduced if i copy paste this link into another cell in the excel 2007 workbook.
This issue does not occur if i link to a cell that has numbers (numeric values).
Is there some other way to link so that i need not (everytime) open the excel 2003 workbook? Any help will be greatly appreciated.
Ajey
I have two excel workbooks, one created in excel 2003 and the other using excel 2007. When i link a cell from the excel 2007 workbook to a cell in excel 2003 workbook (that has some text in it), it shows a "#N/A" message. However if i then open the excel 2003 workbook using excel 2007 (keeping the excel 2007 workbook open), the error vanishes.
In other words i need to open and close the excel 2003 workbook to have the link work correctly.
This issue can be also reproduced if i copy paste this link into another cell in the excel 2007 workbook.
This issue does not occur if i link to a cell that has numbers (numeric values).
Is there some other way to link so that i need not (everytime) open the excel 2003 workbook? Any help will be greatly appreciated.
Ajey
