Arie Bos
Board Regular
- Joined
- Mar 25, 2016
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
I use a workbook A containing lot of data. Then, WB B reads from WB A, and WB C reads from WB B. (ABC in same folder)
When I open up WB C, it asks for Update / Don't update.
If I don't update, the file opens normally. But when I do update, something strange happens: in VBA Project explorer, it shows extra worksheets without names for each 'real' sheet in the book. This does not happen when I do not update. These ghost files cannot be removed anymore. Sometimes there are even more 'ghosts' for each 'real' sheet.
I created a new workbook, moved all 'real' sheets into that, and saved under same name. So, clean again I thought, but when I reopen it, update, the ghost sheets turn up again.
Is this on purpose by Excel?
When I open up WB C, it asks for Update / Don't update.
If I don't update, the file opens normally. But when I do update, something strange happens: in VBA Project explorer, it shows extra worksheets without names for each 'real' sheet in the book. This does not happen when I do not update. These ghost files cannot be removed anymore. Sometimes there are even more 'ghosts' for each 'real' sheet.
I created a new workbook, moved all 'real' sheets into that, and saved under same name. So, clean again I thought, but when I reopen it, update, the ghost sheets turn up again.
Is this on purpose by Excel?
