Hello all!

I have tried to save a workbook several times in the last 2 days and it keeps giving me an error message but I don't understand why. I have an original workbook, which will allow me to make changes and save just fine. I can also run the needed macro on it with no problem.

I made a copy of the original data sheet from that book in a new workbook, so I could play with a smaller data sample. (I've been trying to understand exactly how the macro works, step by step). I started this on Tuesday and everything was okay until the end of the day. When I went to save that smaller sheet to look at some more today, it would NOT save! The error it gave me, several times, was:
"Errors were detected while saving ':\Macro practice.......\Book2.xlsx. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."
I tried clicking Continue and then it told me that the errors were SO awful that they couldn't be fixed! Next time, I clicked Cancel and, of course, it prompted me to save the book before closing it. I went aroundn those 2 circles a few times, then just dumped the book and went home for the day.

So, today, I started all over - making a copy of the original data sheet in a new book, paring it down to a minimal number of rows, and successfully saved it before I started working with it; YAY! I made 2 extra copies of the now-shortened raw data and tried to save it and got the same error message from Tuesday.

I even tried creating a new, blank workbook and then copying and pasting just the raw data - no formatting or anything - on Sheet1 and that WILL save! But why would it let me save twice with the original formatting in the other book and then not let me save the third time? And why would the original, original book have been saveable for probably 6-7 years now, even today?

Any idea what's up with this?

(To be honest, the macro isn't working perfectly like it used to, although the data I'm looking at now is a copy of the data in use when the macro was created)

Thanks for any insights!

Jenny