![]() However, Regarding my approach, you mentioned " approach you use doesn't work. I added the details of where I got the file from at the bottom of this response just in case if you are interested and also other folks who may be reading this response. I wonder what those hidden links are and why would it be there in the temp location. I downloaded Findlinks add-on and executed it myself. To resolve you need to query such table and merge with main one on unique ID within same query.Īttached is the file in which removed everything except sheets with queries, you may check how it Baklan You are a lifesaver! You may change sorting of such table and refresh - values in additional columns will be on another positions. ![]() You add manual columns with some data, but they won't be in sync with the main table returned by PQ. With that Power Query itself works relatively fast.Īnother story is that approach you use doesn't work. ![]() In addition I'd recommend to set Ignore privacy setting for this file, you don't need it with this data structure. Using FindLink () I delete all of them.Īs an example hidden NameěExCUSR1TLT2YXF5OVHCGT9D0CIS ='\\PHCHBS-S3047.EU.NOVARTIS.NET\SAULJA2$\DOCUME~1\bullimi1\LOCALS~1\Temp\N.notes.data\Table'!$I$11:$J$11ĝeleted On Refresh Excel tries to update them and it takes time. Your file there are few thousands of links on external files which are in hidden name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |