Has anyone discovered anything to cause this? I have the opposite problem, Excel used to (and is supposed to) default to copying hidden cells, but now it sometimes does not. An interesting detail is, I have a particular workbook from which hidden data is not copying. I can have it and another workbook with hidden columns both open, copy from the one and the data in hidden columns does not paste, copy from the other and it does. I can't find any setting for this and the only references I see in help are how to copy without the hidden data (since copying it is the default.)
Bookmarks