• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formulas in headers of Excel table

I tried to use formulas in headers by following this video:


by repeatedly I get this message: [Expression.Error] 31-01-2025 of the table was not found.

when I change month from January 25 to February 25 (or another month)

Any help?
 

Attachments

  • Formulas_in_Headers.xlsx
    23.3 KB · Views: 4
I must be missing something big, because having watched the video I can see no earthly reason you might want to do this!
What are you trying to do?!
 
Hans
I think that, if you go into the Advanced Editor you may have the line that attempts to apply a data type to the heading by its former name.
Removing that applied step might sort the problem.

I usually fake the headings above the Table in Excel and show the actual table without the header row showing. The structured references are not much use then, but one can still access columns by using XLOOKUP on the dummy header row to return values from the table body.
 
Back
Top