FG
💻 Software

Formula in table header cells

Fresh7 days ago
Mar 15, 202641642 views
Confidence Score0%
0%

Problem

I have a table in Excel 2007 that I want to summarise, in a similar fashion to a Pivot Table, but for various reasons I can't use a pivot table. I like the "Format as table" features of sort and filter buttons, automatic formatting etc, so have used that to create a simple table: The numbers are re…

Error Output

A            B            C                    N 
   +-----------+------------+------------+-------+------------+
 1 |           | 01/01/2010 | 01/02…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Formula in table header cells

Low Risk

It is only static text for headers because they are and therefore can be referenced. If they were dynamic, it would wreak havoc with formulas using them as references.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment