• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Track Formatted cells or data in Shared File

R

Rajender

Member
Hi All,

I have an excel file in shared location.
Now issue I am facing now is that every time my team mates complaining that they are updating that tracker but after 1-2 days the changes they made there are not available in it.

For that I use Track changes option to cross check why/who is doing this.

But now the second issue I am facing is that track changes does not highlighting the formating changes.

Looking for your expert advice and suggestion, or somebody faced the similar problem ?

Regards,
Rajender
 
Thanks a lot Narayan,

Yes the file is in shared mode and multiple users are working at same time. Also
I check out the below given link, where for Formatted cells or data track changes is not applicable.
Could you please suggest if is there any other workaround, to track which user deliberately changing the formating of excel file ?

Thanks in advance for your suggestions.

Regards,
Rajender

NARAYANK991 said:
Hi Rajender ,

You mention that you have an excel file in a shared location ; is it a shared workbook ?

Check this link :

http://office.microsoft.com/en-nz/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx

It specifically mentions :


Narayan
Click to expand...
 
Hi Rajender ,

Firstly , if users have been informed that they are not supposed to make such unwarranted changes , and they still do so , I think what you need is not more security , but more dialogue with them.

Excel is a user-friendly package , not some proprietary software with in-built security.

If you really want to ensure that users cannot perform certain actions , you need to do one of two things :

1. Put in the necessary safeguards with the help of VBA / third-party software.

2. Create userforms for data entry , and lock the workbook so that users can only enter data on the userforms. Entered data can be fully validated , and thereafter stored in the workbook.

Narayan
 
You must log in or register to reply here.
Back
Top