I can't say I've experienced that. Since the functionality works in a new workbook, I'd suggest copying all of the worksheets to a new workbook and testing the functionality. (You may have to re-define the named ranges in the new workbook.)
Otherwise, zip and post a copy of the workbook and someone here can take a look at it.
Bookmarks