Creative Ways to use Versioning or Tracking in Excel

A

atlcharm

Hello,

I use excel constantly in my job. I constantly make changes to spreadsheets
on a daily basis. Currently in order to keep track of changes I just do a
"save as" and save a new version of the spreadsheet, but this still doesn't
let me know what changes I made unless I indicate it somehow in the name of
my spreadsheet. I did discover that excel has a tracking option. I notice
that if I change a cell value, it will indicate that. If I change the text in
a cell it will indicate that as well. My problem comes when I deleted a
column or row. Excel tracking will just indicate that row 12 has been
deleted. I have no idea what was in row 12 if I come back a week later, so
this information would be useless. It would be nice it it said "xyz" was
deleted from row 12. Does anyone have a creative versioning or tracking
system they use?
 

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

Top