Hello,
I am trying to collaborate on an Excel workbook with other colleagues. We are all using Excel 2010 and saving the file to the same network drive. We have embedded links to a path on the network that we are all able to access. When we open the file, we are prompted to 'update or not update'. If we choose update, it will then say some things can’t be updated. Then, when trying to edit links, it r turns an Error- source not found, etc.
We've gone back and keep hard-coding the links in the formulas, but seem to keep losing them again. How can we ensure that we can allow the source file to change, but don't lose the links?
Thanks in advance for any help you can provide!
I am trying to collaborate on an Excel workbook with other colleagues. We are all using Excel 2010 and saving the file to the same network drive. We have embedded links to a path on the network that we are all able to access. When we open the file, we are prompted to 'update or not update'. If we choose update, it will then say some things can’t be updated. Then, when trying to edit links, it r turns an Error- source not found, etc.
We've gone back and keep hard-coding the links in the formulas, but seem to keep losing them again. How can we ensure that we can allow the source file to change, but don't lose the links?
Thanks in advance for any help you can provide!