sms 16:00 18 Jul 2006

i am trying to simultaneously share an excel file between two computers so that they can have live updates. Can anyone tell me which version od excel can do this

  ArrGee 16:03 18 Jul 2006

Looking forward to the answers you get. I could do with something like that, but I have never come across any versions of Excel that you can synchronise.

  rezeeg 16:24 18 Jul 2006

Share the file and tick the box that says 'allow network users to update the file'?

  Noldi 16:25 18 Jul 2006

I think you will find that if you have a sreadsheet open on 1 computer you can only open it as read only on the second so what you are trying to do is not possible, only by saving and shutting down on 1 before you open it on 2. But this you already know I think. The only person who may have input on this is VOG but I would also be very inerested in this because I use many Excel files on a server.


  rezeeg 16:29 18 Jul 2006

Sorry, Noldi is right - I had missed the "simultaneously" bit.

  sms 16:33 18 Jul 2006

I know that it was not possible previously, but I have since heard that the newer version of excel can do this, but I dont know which one

  ArrGee 16:37 18 Jul 2006

I have the latest version and there is a way of sharing the workspace! Never tried it though. I'll give it a go as soon as I get a chance.

BTW, when I say 'latest', I'm using 2003 Pro SP2.

  VoG II 16:54 18 Jul 2006

Excel 97 click here

  Noldi 18:41 18 Jul 2006

Well ive learnt something.
At home im running office 2000 and that option is there.

  pickle factory 09:41 19 Jul 2006

Won't allow you to view/edit any code on 97 if workbook is shared, don't know about later versions.

  Noldi 13:01 19 Jul 2006

works a treat on office 2000.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?