This is strange. Beginning the middle of last week when I convert my data from a range to a table, checked the box that includes Headers, the "refers to" begins in Row 2, eliminating my Headers.
When I go to Formulas, Named Ranges, "refers to" begins A2 and it is greyed out. My sheet is unprotected. In Table Design > Resize Table > it begins with A1 and the Header Box is checked.
If I create a new sheet and type "=Table1" it gives me all my data without Headers. I work for a large organization where AIT is pretty baffled. It's also affecting my coworkers. AIT has updated Drivers and Windows updates, and even has tried an Office Repair. No effect. I would like to use GroupBy but Headers I need. Anyone out there have any ideas? This is such a pain.
Thanks in advance.
When I go to Formulas, Named Ranges, "refers to" begins A2 and it is greyed out. My sheet is unprotected. In Table Design > Resize Table > it begins with A1 and the Header Box is checked.
If I create a new sheet and type "=Table1" it gives me all my data without Headers. I work for a large organization where AIT is pretty baffled. It's also affecting my coworkers. AIT has updated Drivers and Windows updates, and even has tried an Office Repair. No effect. I would like to use GroupBy but Headers I need. Anyone out there have any ideas? This is such a pain.
Thanks in advance.
