
Mel Paes
Member
Members
Power Query
Power BI
Power Query
Power BI

Forum Posts: 10
Member Since:
May 30, 2015
May 30, 2015

Hi,
I want to rename a few excel files/spreadsheet (they have unique file names) that are linked to a another file (the master file) and they are all within the same folder.
When I rename each of the the files, the link(s) to the master file is broken. How do I maintain or update the link in the master file by renaming each of the excel files. The data is pulled in from each of the excel files into the master file by using different formulas (sumifs, vlookup etc) and they are large files. The folder and files are all saved in SharePoint.
Any suggestions and help would be greatly appreciated.
Regards
Mel

Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 880
Member Since:
December 7, 2016
December 7, 2016

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: B Leonard, Filipa Almeida, Jig Dhimmar, Lorna Henning, Nikita Bhatia
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
