Forum Discussion

Carlene Bedient's avatar
Carlene Bedient
Copper Contributor
May 03, 2018

Features not allowed in Excel Web app

We use Excel web parts to display charts in SharePoint online. Our web parts were working fine for months but now don't show bars due to the reference cell formula not working. When attempting to ope...
Excel Online
Macros & VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
May 07, 2018
Can you perhaps share the formula showing the REF error before and after the fix? If there are any range names involved, please include their formulas too.
  • Carlene Bedient's avatar
    Carlene Bedient
    Copper Contributor
    May 07, 2018

    The formula is below, which for some reason wants to be on two lines. If the formula is on one line, it doesn't work:

    =TEXT([@[Due Date
    (Day-Month-Year)]],"mmmm")

     

    I checked this morning and the spreadsheet I fixed on Friday is broken again. The references worked okay until the spreadsheet was modified, then the formula shows #REF again. It is looking at the date field next to it. 

    The spreadsheet is using table names. Here's a snip of the cells in Excel web app and the Table name. If the spreadsheet is opened locally in Excel, the formula displays okay.

     

    Thank you,

    Carlene

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      May 07, 2018
      Try editing the header (in the table) of that particular column and remove the line break that is in the name (an alt+enter adds a line break).
      • Carlene Bedient's avatar
        Carlene Bedient
        Copper Contributor
        May 07, 2018

        I checked out the formula. Once I took the space out of the the column name of the other cell, which had part of the name on another line, the formula now displays all on one line, but it is still not working.

         

        Carlene

Resources