Report grouping glitch?

Hi there,

I am confused about something. I have a report pulling data from multiple sheets.

I am then grouping the data by Sheet Name.

However, when I do that, the sheet names don't match. This isn't a huge problem, but it makes the associated graphs I create hard to read with the longer sheet name.

The original sheets have been renamed to the shorter name (Osgood 2) in this image, so they are easy to read in the graph.

I don't know where the longer sheet name is coming from since I have shortened all the names.

What did I miss? or what did I break?

Answers