Barring Excel Links?

  • Thread starter Thread starter matt_hobson
  • Start date Start date
M

matt_hobson

Hi,

Have a very strange problem with Excel. We have a reporting tool usin
Excel, where statuses of projects etc. are updated. One problem w
have is that a user has "decided" to have his own version by saving t
his desktop, and linking to his sheet from the main one. He has als
altered the formatting on the one on his PC, and the main one i
locked. Therefore the cells are displayed in a different format, an
he cannot alter that on the main sheet.

Is there any way we can lock the sheet from accepting Links to othe
Excel files, and also if possible blocking the ability to past
multiple cells in, or only allowing pasting content, not formatting.

Mat
 
You could play around with some macros, but if the user disabled macros or just
turned off events, they could become useless, too.

This sounds more like a job for some social engineering. Maybe have a talk with
him and explain why you need everyone to do it one way.

If that fails, maybe it's time to speak to his supervisor.
 
Back
Top