locked
Excel formulas are changed when spreadsheet is uploaded to sharepoint RRS feed

  • Question

  • I am uploading a spreadsheet to Sharepoint that has formulas that link out to a shared drive.  after uploading, the formulas get changed to the webpage of our sharepoint site.  is there a way to prevent this from happening?  thanks

    • Moved by Mike Walsh FIN Tuesday, January 11, 2011 6:20 PM Nothing to do with Excel Services (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Tuesday, January 11, 2011 5:40 PM

Answers

  • Just a thought: Put the file share's path in File-- hyperlink base.

    Please note that I've used mapped drives and UNC (universal naming convention: \\<server>\<share>\) and have more success with UNCs.

    hope this help
    thanks
    -ws

    SharePoint administrator, MCTS,MCITP
    • Marked as answer by Emir Liu Thursday, January 20, 2011 7:10 AM
    Tuesday, January 11, 2011 9:19 PM