Share Data On A Worksheet

[carl]

Is there a way (a setting ?) that would allow a change on a worksheet to be
viewed by others using that worksheet ?

Thank you in advance.

 

[Shane Devenshire]

Hi,

Are you talking about a Shared workbook, or do you want someone who opens
the file to see a highlight indicating that the data was changed?

You can use the Tools, Track Changes command, but your workbook will be
shared and shared workbooks have tons of problems and limits.

 

[carl]

Thank you.

My scenario is that 2 people have the workbook open. 1 person is responsible
for updating the information in the workbook. When the information is
updated, the second person sees the new info.

Is that possible ?