Marco Baccolo 2 Posted June 1, 2023 Share Posted June 1, 2023 Good morning, I am using Evernote, last edition, to collect information regarding two main books ( companies and projects ) and I use an EXCELL ( Microsoft 365 ) data base to elaborate some of that information. The connection between the two programs are the titles of the notes through the linked names. I use Mac platform and all is ok. Now I need more functions to elaborate my data that EXCELL hasn’t on Mac platform and I migrated to EXCELL for windows. I am using a virtual machine by Parallel. I open EXCELL data base and I find all sheets and information, but the links to Evernote don’t open the right note. Means that I enter in the Evernote application but not in the right position. Suggestions ? Link to comment
Evernote Expert agsteele 3,059 Posted June 1, 2023 Evernote Expert Share Posted June 1, 2023 I never thought I'd say this but, as I get older, I need a bit more clarity in the text that appears on screen. Perhaps you could chose a darker font colour. I copied the text to another application so I would suggest that you go to the home of the forums and search for Excel. You might find some useful conversations there. Link to comment
Level 5* gazumped 12,057 Posted June 1, 2023 Level 5* Share Posted June 1, 2023 1 hour ago, Marco Baccolo said: The connection between the two programs are the titles of the notes through the linked names. I use Mac platform and all is ok. Hi. It would also be helpful to us to see an example link/ screenshot - are you linking to the Evernote note, the XLSX file or where? When you click on your link what do you see as the results? Link to comment
Marco Baccolo 2 Posted June 3, 2023 Author Share Posted June 3, 2023 Thanks for your attention.I am enclosing 3 Screenshot. 2 are by Excell in Windows and the last is the result in Evernote on MacOS platform. If I change the name of the company on Excell the linked name in Evernote is always the same.If I repete the same operation having EXCELL and Evernote on MacOS platform everything is OK. Link to comment
Level 5* gazumped 12,057 Posted June 3, 2023 Level 5* Share Posted June 3, 2023 Hi again - in general, links are a one-time copy of the URL and its associated text. Link to a note titled "Foo" and your link will show "Foo". Change the name of the item to which the link applies to "BAR" and the link (I think) will still show "Foo" but you'll wind up at "BAR" if you click it. I.E changing the name of an item in Excell is not reflected in anything linked to that item (AFAIK) in Evernote or anywhere else. In the same way that you can edit the link in Evernote to say something unrelated to the actual target, changing the name of the target doesn't affect the link, which actuallly works on a unique identifier unrelated to anything... Link to comment
Marco Baccolo 2 Posted June 3, 2023 Author Share Posted June 3, 2023 Thanks. I have a note on Evernote Name "Foo". I get the Link of this note and I copy the name of this note "Foo" and relative link into a cell of Excell. Before testing the functionality of that connection I must add a / in the Evernote link in Excell modifying the original link. In this mode all is ok. I have always a connection between the relative note "Foo" and the cell "Foo" in Excell. This happened when Evernote and Excell are in the same platform MacOS. My Problem is coming when Evernote is on macOS platform and Excell is on Window platform. In the screenshot you see the cell "Miba" on Excell Window go to "MTA" in Evernote MacOS. The same on MacOS platform is OK. Link to comment
Marco Baccolo 2 Posted June 3, 2023 Author Share Posted June 3, 2023 I use Mac and I have a Virtual Machine for Windows with Parallel Link to comment
Level 5 PinkElephant 8,779 Posted February 12 Level 5 Share Posted February 12 On 6/3/2023 at 6:08 PM, Marco Baccolo said: I use Mac and I have a Virtual Machine for Windows with Parallel I can't try myself, since I don't use Office at all. But I think the problem is with the VM, and how it handles the conversion of actions between Windows in it's sandbox, and applications on the host Mac. Probably you could work around it if you install the EN client inside of the VM as well. Link to comment
Level 5* gazumped 12,057 Posted February 12 Level 5* Share Posted February 12 17 minutes ago, davidjohn87 said: I appreciate your dedication to organizing your information using Evernote and Excel I love the smell of AI-sourced posts... 1 1 Link to comment
Level 5 PinkElephant 8,779 Posted February 12 Level 5 Share Posted February 12 Smell it, then nuke it, I would say 🤯 1 Link to comment
Level 5* gazumped 12,057 Posted February 12 Level 5* Share Posted February 12 Actually I didn't notice it was also cunningly (!) disguised Spam or I would have zapped it initially. The post is now nuked. 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