Forum Discussion
Help needed! share data between worksheets
Darren_Melbs Like you said well this is a disappointing, lack of feedback
- 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.I'm not a Mac user... Hope mathetes will be able to help and you'll find a solution sooner or later
Appreciate your reply - Thanks
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.
- Okay. 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
