Forum Discussion
Darren_Melbs
Dec 12, 2022Copper Contributor
Help needed! share data between worksheets
Hi all, first time user, so please go gentle 🙂 I am using Microsoft 365 work account with the suite of products etc and I'm struggling to get two seperate Excel worksheets to share data, surely...
Lorenzo
Jan 15, 2023Silver Contributor
Darren_Melbs Like you said well this is a disappointing, lack of feedback
Darren_Melbs
Jan 16, 2023Copper Contributor
Yes. Thanks LZ. I’m not sure what happened to my post, however I did reply.
Basically I said Thanks for your detailed explanation, it is between two seperate workbooks, I did try locally on my computer first, it simply adds the written link, so perhaps it’s a Mac issue?? It could be an issue with my Mac Excel, it is the enterprise version also. I know in the past I have managed to link on my old computer, so that is why I knew it does work.
I’ve tried your solution, however for some reason it hasn’t worked.
I appreciate your help thus far. Cheers.
Basically I said Thanks for your detailed explanation, it is between two seperate workbooks, I did try locally on my computer first, it simply adds the written link, so perhaps it’s a Mac issue?? It could be an issue with my Mac Excel, it is the enterprise version also. I know in the past I have managed to link on my old computer, so that is why I knew it does work.
I’ve tried your solution, however for some reason it hasn’t worked.
I appreciate your help thus far. Cheers.
- mathetesJan 16, 2023Gold Contributor
I'm working on a Mac (actually, I have three different Macs); I have a number of workbooks that work by calling on data in other workbooks.
I've attached the simplest of examples. One workbook called "Source.xlsx", the other "Secondary.xlsx" with the latter pulling data from the former. "Source.xlsx" needs to be open at the same time, especially if you're going to be changing the data in it and expecting the results to appear in the other.
If this isn't the kind of thing you're talking about, please be a bit more specific with the links you're trying to create.
- Darren_MelbsJan 22, 2023Copper ContributorOkay. So I’ve just attempted to open your file and instantly it comes up with an error stating “Links Disabled - Links to external workbooks are not supported and have been disabled.”
So if I had to guess, this might be an administrator issue, on my work network.
I’ll chase that up and let you know if I get any success from it.
Cheers