Share via

Excel error when upload to OneDrive

Anonymous
2021-05-06T18:35:58+00:00

Excel formula to show tab title in a cell is not working when I upload the file to OneDrive

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Works fine in desktop app. OneDrive shows error #VALUE!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2021-05-06T21:19:33+00:00

OneDrive is where the workbook is saved.

Excel Online is where you open the workbook in the browser, as opposed to Excel Desktop.

The CELL function works in Excel Desktop but is not supported in Excel Online.

There is no worksheet function replacement for Excel Online. You could write an Office Script, which is based on JavaScript, but this is not a very mature technology yet, and I don't expect it to be widely used for a long time.

When the file opens in Excel Online, click the Open in Desktop App button in the ribbon.

Was this answer helpful?

2 people found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-06T21:29:28+00:00

    There is a petition in Excel User Voice to make the CELL function work in Excel Online. Go to the link below and vote for it. Suggestions with more votes have a greater chance of being implemented. https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/17098492-cell-function-added-to-online

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-05-06T22:05:44+00:00

    Ah I see. As long as I open the spreadsheet in the desktop app the formula will work.

    Thanks,

    LaMonte

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-05-06T20:06:52+00:00

    When excel file is opened in desktop app the formula populates the cell with the web address for the OneDrive document. Open in OneDrive #VALUE! shows in the cell.

    Hmm

    LaMonte

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-05-06T19:42:34+00:00

    What does this simpler formula return in desktop and OneDrive:

    =CELL("filename",A1)

    Was this answer helpful?

    0 comments