mrkcvr 3 Posted January 23, 2021 Share Posted January 23, 2021 I have two Excel files in different EN notes. One is dependent on the other. Outside of EN the first sheet's formulas get automatically updated upon opening the second one. Now, within EN, I get an error message within Excel saying that it cannot update the linked cells. Is this not supported within EN or am I setting things up incorrectly? Link to comment
Level 5* DTLow 5,744 Posted January 23, 2021 Level 5* Share Posted January 23, 2021 15 minutes ago, mrkcvr said: I have two Excel files in different EN notes. One is dependent on the other. You don't want to embed these spreadsheets into the Evernote database Store them externally and in Evernote reference the spreadsheets using a file link >>Is this not supported within EN No. The files have been removed from the file system and cell links are no longer valid Link to comment
mrkcvr 3 Posted January 23, 2021 Author Share Posted January 23, 2021 Thanks. Sorry for the naïve question. Do I simply make a shortcut or how do I make the link from, for example, my Documents file in Windows to the EN note? Link to comment
Level 5* DTLow 5,744 Posted January 23, 2021 Level 5* Share Posted January 23, 2021 10 minutes ago, mrkcvr said: Do I simply make a shortcut or how do I make the link from, for example, my Documents file in Windows to the EN note? I'm not a Windows user but I think the url will be something like file://c:.. Be aware - we currently have to use the Legacy product to create the link Link to comment
mrkcvr 3 Posted January 24, 2021 Author Share Posted January 24, 2021 I did a little playing around and I seem to have found a solution. Place the Excel file in a Windows folder In the same folder, make a shortcut of that file Insert the shortcut into the EN note Delete the shortcut in the Windows folder. Link to comment
Level 5* gazumped 12,062 Posted January 24, 2021 Level 5* Share Posted January 24, 2021 10 hours ago, mrkcvr said: I seem to have found a solution. Whatever works... Actually, if you Shift+Right-click a file name (Windows) you should get an option "copy as path" which will put the complete link to that file on clipboard. It'll be in quotes, which you then have to delete; but it's a lot fewer keystrokes! Link to comment
mrkcvr 3 Posted January 24, 2021 Author Share Posted January 24, 2021 Yes I tried that as well, and it does work. The shortcut method gives a "nicer" looking note. 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now