Excel networking

  sms 10:59 10 Jun 04
Locked

I am running an excel spreadsheet as a booking programme.
Is it possible to access through another computer and take bookings at the same time as it is open in the other computer.
Any other suggestions welcome

  Shas 13:05 10 Jun 04

If I've understood you right, I don't think so. I have two computers networked to each other, (with file sharing enabled), and if I open an Excel file on one, then try to open the same file on the other I get the message: " ..... is being modified by ..... Open as read only or choose notify to be alerted when available".

Mind you, I only have Excel 97 so more up-to-date versions may allow it.

  VoG II 14:00 10 Jun 04

I think that you will need to create a shared workbook http:// support.microsoft.com/?kbid=269860

  VoG II 14:00 10 Jun 04
  Shas 14:38 10 Jun 04

That's handy to know. Just have to keep saving all the time because any changes don't appear on the other workbook until you've hit save on that computer, and the shortest autosave time is 5 mins, (but that beats having to keep running up and down the stairs!)

  sms 14:21 11 Jun 04

Thanks for the info.
Yes it is a shame you have to save all the time for the changes to take effect. Is there a better method or is that the best available

  Shas 15:07 11 Jun 04

Had a root around but can't find anything :o(

  sms 14:24 12 Jun 04

Is there any way to lock the keyboard rather than lock the computer

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…