Forum Discussion

Black_Square's avatar
Black_Square
Copper Contributor
Mar 04, 2024

Issue with Named Item

 

 

Hi,

 

I wanted to insert a chart from my spreadsheet into Sharepoint, however I received message below. Can somebody please advise as to how to designate the chart as a 'Named item'? I am using excel Home and Business 2021 on my Mac. 

 

Thank you in advance

 

 

Excel on Mac

1 Reply

  • Smith9's avatar
    Smith9
    Iron Contributor
    Jun 05, 2025

    Error reporting names can be removed and redefined via “Formula > Name Manager”, forced refresh of formulas can be done using =IFERROR(original formula, “Alternate Value”) for error tolerance, press Ctrl + ~ to display all formulas and look for #NAME?errors when batch checking.

Resources