linking multiple workbooks: #n/a error

[mhaenick]

I am using excel 2007 to create a series of linked workbooks in excel 97-2003 format on sharepoint.

I have one source file that links to 32 destination files. The source file contains multiple tabs. All values are text. I am copying a cell range and using the paste link function in the destination. The destination is formatted exactly the same as the source. all cell addresses in both source and destination files are exactly the same.

I am encountering an "#n/a" error when opening the destination file. Frustratingly, cells within the same pasted range are updating normally while others are not. When the source is opened the destination usually updates.

Please help! All efforts to research this issue have been fruitless.

 

[kdlenort]

I have the same issue in Excel 2003 but only when the main linked workbook is password protected. An answer as to why would be great as my research has come up with no explaination or reason.

 

[mhaenick]

Have been experimenting further and noticed that in instances where my source cell had a hyphen in the text, removing the hyphen seemed to help correct the problem.

Not sure if the hyphen is the issue or if simply updating the cell was. Either way, still experiencing the problem with some cells without hyphens or other non-text characters.

 

[mhaenick]

Saved workbooks on my computer and still experienced the issue. Rule out SharePoint as part of the problem?

 

[kdlenort]

Are your workbooks password protected?

 

[mhaenick]

the source is not. the destination file worksheets are protected. Even when un-protecting them, still experience the issue.