OneDrive


Feedback by UserVoice

I suggest you ...

Fix problem that changes linked Excel file location

When creating a link between data in two Excel sheets without OneDrive, the program links to the file location on the hard drive. Once OneDrive is in place, Excel forgets the hard drive location and tries to link to the OneDrive web location which results in an error message. This is a MAJOR problem. This renders one of the most vital functionality of Excel useless!

33 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Bill shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Doug Scott commented  ·   ·  Flag as inappropriate

    As a workaround you can do a Save As on the Excel file with links to other workbook and it will not change the links to web location but will leave them pointed to the local OneDrive location.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I totally agree. Ran into this problem with a client today that MOVED from Google Drive and Google Sheets to O365. Free Google Drive does this flawlessly and a paid subscription of Office 365 with OneDrive CAN NOT! Embarrassing. Please allow LINKS in excel sheets to work with OneDrive.

OneDrive Archive: Bugs

Feedback and Knowledge Base