I use an excel 2013 spreadsheet as a master template. It pulls data from other spreadsheets located on a shared drive. When I upload the master to sharepoint sharepoint changes all the paths to sharepoint path.
See these examples:
Before
=+'G:\Service Transition\TPS\1. PI\Monthly Management Report\Factory Review Log\[Factory Review Log.xlsx]
After
=+'http://atlasmoss/ServiceTransition/TPS/PI/Document Repositories/Monthly Management Reports/[Factory Review Log.xlsx]
If I use the master as a 2003 excel spreadsheet (XLS) the path remains the same.
Question
How do I lock the path to stop sharepoint changing it?
