I have created this archive of two files that work together on my system to see if this method will work when downloaded.
Didn't work right off. I opened the archive and then opened both files at the same time and enabled editing. I had to change the formula in R6 to:
and change the formula in R7 to:
If there are still errors, make sure that the formula in Sample - ndm.xlsx sheet2 is:
Once that is done, all errors should disappear and when you save the workbooks they should open and work correctly. The two-way links is the problem but when corrected, the setup works fine.
Bookmarks