Hi All.
Excel 2013 - don't know if this problem exists in other versions.
Ok... Here it is. I have a text box referencing a cell and grouped with other text boxes and shapes. The text box and the reference cell are on the same sheet. When the cell is updated, the text box updates. But, when I copy the sheet to a new sheet, the text box does update when the cell on the new sheet is changed. The text box does reference the proper cell in the new sheet.
On the newly created sheet, if I select the text box and hit F2, then hit enter, it starts working again - like re-entering the formula.
If I do not group all of the many text boxes and shapes together, then copy the sheet to a new sheet, the text box updates when the referenced cell is changed - works properly.
If I copy the group and paste it onto the same sheet or different sheet, the text box updates properly with the referenced cell. It only does not work when the text box is grouped and I copy the sheet to a new sheet (ctrl-drag the tab, or right click on the tab - move or copy)
I need these grouped together, because the many text boxes and shapes will need to be copied to a different sheet later and it would be annoying to try to have the users select all shapes and text boxes prior to copy.
Thanks for the help in advance.
Steve
Bookmarks