Linking workbooks; experiencing random "#n/a" error

M

martin

I am attempting to link multiple (~35) workbooks from a single source. The
destination workbook is displaying "#N/A" on some cells, while others (with
the same protection properties) are updating without issue.

A little more info: The source and destination workbooks are identical in
terms of formatting, cell locations and tabs. The destination workbook has
been created by selecting cell ranges and then utilizing the "paste link"
function. The destination workbooks must also be protected at both the
workbook and sheet levels.

Any assistance is greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top