I had a calculated field in a table that I was using to populate a PivotTable. All the other fields appeared in the field list, but no matter what I did, the calculated field wouldn’t show up. Refreshing, closing and opening the file didn’t work, exiting and re-launching Excel didn’t work. What finally worked: closing Excel and leaving the computer alone for a day. The following day, the field appeared in the list and I was able to use it in the PivotTable. Weird.
In partnership with Experts Exchange. If you ever wanted to insert a checkbox in an Excel worksheet, you know it wasn’t easy or straightforward. But