Forum Discussion
Excel linking
Hey all, We are in the middle of a project which will involve moving our Excel files to a different location, and I would like to know how Excel handles links. For example, this is our curren...
Hi Nauthstar ,
I have a similar problem with this. I am using PowerPivot, so I have to update the links, which is fine manually, but the question I have is whether the formulas I put in my data model of power query will be affected. Do I need to work on them again?
I have a similar problem with this. I am using PowerPivot, so I have to update the links, which is fine manually, but the question I have is whether the formulas I put in my data model of power query will be affected. Do I need to work on them again?
I would try to test this out yourself, as each case could be slightly different, based on the way user set up.
The way I'd go about is to go to my source file (assume EXCEL) and change one of the entries to 99999999 - something large. Then do your other changes and see if it pulls through to Power Query correctly. If so, change the 9999999 back, otherwise, investigate further.
