What is the difference??
I have been playing about with using a new connection to pull in source data vs just writing my formula then linking to the source data by having the workbook opening then highlighting the cells I want to pull in whilst writing the formula
By linking it shows in links but not connections. Surely a link is a connection????
I don't get why my links wouldn't show
Both methods auto update when I hit refresh
Connections are to other structured data sources other than Excel files.
https://support.office.com/en-us/art...d-d22a2eea2d46
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
oh riiiiiiiight, that makes sense
So should I be using it to connect to other excel files or just use linking in the formula so that it show in data>edit links?
Just using regular formula links is the simplest for connections to other workbooks. EDIT LINKS makes it simple to update when those workbooks are in new locations.
ahh brill
thank you for your help! appreciate it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks