Showing results for 
Search instead for 
Do you mean 
Reply

Track changes made to an Excel sheet through Teamcenter

Hi,

I would like to know if there a way to track changes made to an excel sheet through teamcenter. Like a log would be created recording any changes made to the sheet or compare two versions of the excel sheet in teamcenter. Also I would like to know if the markup option available for MS Word files is also available for MS Excel sheets.

 

thanks and regards,

Sanket Pusalkar. 

4 REPLIES

Re: Track changes made to an Excel sheet through Teamcenter

[ Edited ]

Hello Sanket,

 

Considering the end user perspective, if it is related to changes made in document content, I will use default functions available in word as well as excel.

 

For word document, 'Track Changes' with 'Show Markup' option. You can use 'Compare' option within the word document by opening the two different versions of dataset from Teamcenter.

 

For excel document, 'Track Changes' will enough as it will highlight the cells that has been changed.

 

Testing NX10 | NX11
Teamcenter 11.2 | TC Vis 11.3 | Active Workspace 3.2

Re: Track changes made to an Excel sheet through Teamcenter

Dear Ganesh,

Thank you for your reply, as you proposed the default functions in MS
Office application is the
only feasible way to track changes to MS Office documents. Is there a way
that the 'Show Markup'
option present in MS Word can be made available in MS Excel as well?
That would be really great solution for my scenario.



Thanks and Regards,
Sanket Pusalkar.

Re: Track changes made to an Excel sheet through Teamcenter

Show Markup option is not available in excel. I don't know if there is any other way to achieve it. But when you use Track Changes option, cells get highlighted with comment for each cell which describes the changes done to it.

 

Testing NX10 | NX11
Teamcenter 11.2 | TC Vis 11.3 | Active Workspace 3.2

Re: Track changes made to an Excel sheet through Teamcenter

Dear Ganesh,
You are right, markup option is not available in MS Excel, that would have
been the best solution in my case.
Nevertheless, thank you for your prompt reply.



Thanks and Regards,
Sanket Pusalkar.