0
Undo
Votes
I'm getting a "This Notebook Never Saved" error when I try to Split a Workbook into separate files. I've attached a video of what is going on.
I have an Excel spreadsheet with 50+ worksheets. I would like to save each worksheet seperately. However, after saving the workbook and running the Split Workbook macro, the resulting saved files do not have the data fields in them and there's an "This Notebook Never Saved" message in one of the cells. Any thoughts as to how to fix this?
[video]https://screencast-o-matic.com/watch/criU2bVisYt[/video]
I have an Excel spreadsheet with 50+ worksheets. I would like to save each worksheet seperately. However, after saving the workbook and running the Split Workbook macro, the resulting saved files do not have the data fields in them and there's an "This Notebook Never Saved" message in one of the cells. Any thoughts as to how to fix this?
[video]https://screencast-o-matic.com/watch/criU2bVisYt[/video]
There are no replies made for this post yet.