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!!!!!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

picture in comment in cell 0
Excel comments disappear in new file after using Save As command 0
Max Comment Limit? 8
Copy worksheets and save files dynamically 3
Excel 2007 File Saving 1
Losing Excel Formating 0
Automatically Linking New Spreadsheets to Master File 1
Office2007 "compatibility mode" screwing up formatting in Excel 20 0

Top