Excel

  sms 16:00 18 Jul 06
Locked

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 06

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 06

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

  Noldi 16:25 18 Jul 06

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.

Noldi

  rezeeg 16:29 18 Jul 06

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

  sms 16:33 18 Jul 06

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 06

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 06

Excel 97 click here

  Noldi 18:41 18 Jul 06

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

  pickle factory 09:41 19 Jul 06

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 06

Yep
works a treat on office 2000.

Noldi

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5