locked
Microsoft Excel 2013 & Sharepoint RRS feed

  • Question

  • 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?

    Monday, September 1, 2014 3:47 PM