Hi
I have numerous spreadsheets used for various reporting all of which sit in various locations on my J drive (mapped network drive) My company wants everything moved to teams to make it easier for collaboration etc but I am worried that the literally hundreds of links and lookups will be lost or at least need to be reset.
Is this a valid concern or is there a way to move the spreadsheets retaining the spreadsheet links and lookups to the files in the new Teams location
Part of the reason for this move is that some linked sheets are used as source data for reports but sit in different folders than each other and it appears to make sense to tidy the whole thing up ( same files and folder locations for last 10 years at least)
Thanks
Rick
I have numerous spreadsheets used for various reporting all of which sit in various locations on my J drive (mapped network drive) My company wants everything moved to teams to make it easier for collaboration etc but I am worried that the literally hundreds of links and lookups will be lost or at least need to be reset.
Is this a valid concern or is there a way to move the spreadsheets retaining the spreadsheet links and lookups to the files in the new Teams location
Part of the reason for this move is that some linked sheets are used as source data for reports but sit in different folders than each other and it appears to make sense to tidy the whole thing up ( same files and folder locations for last 10 years at least)
Thanks
Rick