authorship documents word and excel

Question

question

FERNANDOJOSEBERBEGALGARCIA-8082 asked · Feb 28 at 08:54 AM

authorship documents word and excel

Hello,

Do you know a way to control the authorship of a word and excel document? We currently use office 2016 desktop, I don't know when it is planned to upgrade to the desktop version of 365.

I really need to know if my students copy the exercise that I send them or do it themselves, until now I used the metadata to authenticate author, creation date, modification date and edition time, but my students know how changed it or if they used "save as" all the most important metadata that I need are reset.

As I usually give them a basic docx document, I thinked one way and is to use the change control, but it should be in the background, hidden from the student, also using the key to prevent it from being deactivated, but word shows the comments as soon as the document is opened , is what I would like to avoid, so the comments are saved with date and author, and I would visualize it.

I would also need it in excel.

office-itpro

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-03-01T08:02:05.007Z

emizhang-msft answered · Mar 01 at 08:02 AM

Hi @FERNANDOJOSEBERBEGALGARCIA-8082,
Based on your description, in my opinion you're looking for Track Changes feature in Word and Excel.

For Word, you can go to Review- Track Changes- Select Lock Tracking, then you need to enter the password to help you prevent from users turn off the Track Changes feature, please refer to this support to get more help:

https://support.microsoft.com/en-us/office/track-changes-in-word-197ba630-0f5f-4a8e-9a77-3712475e806a

For Excel, first go to File- Options- Customize Ribbon- select All Commands- add Track Change(Legacy) to New Group:

Any updates please let me know and I'm glad to help you. Hope the information is helpful.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

312.png (29.1 KiB)

313.png (52.6 KiB)

·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2021-03-01T13:43:54.28Z

FERNANDOJOSEBERBEGALGARCIA-8082 answered · Mar 01 at 01:43 PM

Hi emizhang-msft,

thanks for you answer, It's a big solution, but has a little problem, because when the student open the document, he view the track changes always. if there are'nt more solutions, I apply it's

thanks

· 1 ·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft · Mar 03 at 09:45 AM

Hi,
As far as I know track changes option is based on the user's app but not the file.
In Word maybe you can try to run a Macro:

 Sub Macro3()
 With ActiveWindow.View.RevisionsFilter
         .Markup = wdRevisionsMarkupNone
         .View = wdRevisionsViewFinal
     End With
     ActiveWindow.ToggleShowAllReviewers
 End Sub

0 ·

question