I have an Excel file in which some of the cells are linked to another workbook. It’s a link to a single cell in the other book. Example formula:
c:\all users\desktop\[workbook1.xls]sheet1!$c$30
The problem is all the cells linked to column C are giving me this error: #DIV/0!. I checked workbook1.xls and there are numbers in column c and when I open the workbook1, the numbers shows in my linked workbook, but when I save and close the workbook, the numbers disappears and the errors appear again.
The other cells such as D, E are all fine not giving me an error it is these particular column. Why?