Excel comments are lost in the new file after using the Save As

K

Karleen

I do budget forecasting and each time I update my forecasts, I save the file
with the current date.

Recently, whenever I save the file (using the Save As) function, the
comments disappear from the new file. When I reopen the original file, they
are there.

Why aren't the comments copying over? This just started. Earlier this week
I had to go through 10 worksheets and Paste Special, Comments for all of the
comments I needed. As you can imagine, there are hundreds due to budget
changes.

HELP!!!!!!!!! Any help would be greatly appreciated!!!!!!!!!!
 
Top