Hello,
I have 2 calc : calc1, calc2
In the calc2, I was able to do in A1 a ref to calc1.A1. It’s pretty straight foward.
My cell A1 in calc2 was :
=‘file:///C:/Users…calc1’#$sheet1’.A1
It worked just fine, until I add some “fancy” hyperlink.
I added (in calc2) some hyperlilnks to jump fast to other sheets, within calc2
I did 2 things :
- F5 (view>navigate), then drap and drop an anchor of the sheet I wanted to jump on
- CTRL+K > Document > Click on the cercle at the right of the “Target” field, then select a sheet from calc2 > apply > ok.
It created my hyperlinks ( two types of hyperlink). So far so good : calc2 contains ref to calc1 and hyperlinks
Then I saved and all ref to calc1 broke instantly.
Short story : now when I do a basic ref to that calc1 it does not work ( #REF!) , but if I do a ref to another doc, like calc3 it works.
calc2 contains ref to calc1 but with error #REF!
calc2 contains ref to calc3 and it works
I did try to remove/disconnect all external source from the document (Edit > link to external file). Close/reopen. Nothing is working.
Edit : When I re-open calc 2, I have a message “update of external link is disable > allow update”. Before I click to allow the update, the error in the cells is Err:540 and when I click, the err switch to #REF!
But I’m sure of the link since the link is generated by calc itself and the link of calc1 and calc3 are exclatly the same (except the calc name ofc)
Edit2 : If I rename calc1 into calc1v2, it works 
If I rename it back to calc1, still not working
What did I do and how can I “recover” that “feature”?
Thanks,