just a quick question, if I wanted to share a spreadsheet between 2 computer and have it continually updating every, say, 5 mins, is there anything I can do apart from using the "Share workbook" feature?

what exactly are you trying to do;
if the book saves you could try using a breifcase, or synctoy or something to that effect,
other thought use dhtml and php or something and have it set up like a webpage

why not try the google spreadsheet thingy? that is quite handy...

quote:

---

Originally posted by foaly
what about the google spreadsheet thingy that is quite handy...

---

quote:

---

Originally posted by xen0h
what exactly are you trying to do

---

If it is a simple spreadsheet I'm sure if you Google you can find PHP scripts that can edit them. This way when your parents edit the data in their web browsers, you too can edit the data from your web browser.

I believe Excel in Office 2007 still uses Comma Separated Variables (CSV) which easily allows the data to be edited. You could easily convert the data to fit into a MySQL database, which you could download/ upload once changes are completed .

It sounds a more complicated approach, but it is the only thing I can think of.

This might be what you're looking for: http://www.xcellery.com/

quote:

---

Stop emailing and consolidating your spreadsheets! Xcellery lets several people modify the same Excel file at the same time. No installation required. It's free!

---

i think i know you use office 2007 right doesn't that come with igroove or something to allow file syncing?

Review > Share Workbook > tick the checkbox and then go into the advanced tab for saving details and stuff. 

I'm sure you are smart enough to work out all of the minor fiddly stuff (especially seeing as though I only have the one computer here atm and cant test it out)

i think he knows that

quote:

---

Originally posted by MattyRid
is there anything I can do apart from using the "Share workbook" feature?

---

quote:

---

Originally posted by xen0h
i think he knows that

---

If they're modifying it when your not around, you could try just keeping the file on a network share.

Sometimes folks use a spread because it's handy and they are familiar with it, not because they need number crunching. Some other folks might use a word processor for the SAME THING, again, because it's handy and they are familiar with it; often we're talking about just recording some simple facts.

After you figure out exactly why you intend to use the spread, try to figure if you could do the same job with a wp.

If you can see how that would work for you just as well, consider this...

set up a free and awfully easy website at googlepages (ok at wp-type stuff, probably not-good at spreadsheet stuff) and put your data there. let your folks have the logon and pw so they can edit the pages too.

There you have a simple way for everyone to make updates without a lot of other bother. Print out as needed! I think it even keeps track of the last time you logged on and made changes.

I like simple. This seems simple to me. Hope it helps.
seeker1

If you are using a copy off Office Pro 2007 you can use Microsofts new application called Groove. I use it to keep some file the same between my laptop and my PC. I also have people I work with editing files between me and them using Groove. If you want to learn more Click Here.

Finally worked it all out after trial and error, based on what markee said, I was on the path to want I wanted and managed to get the right one (see the attachment). Man  Excel (and Office) 2007 is a pain in the prosteria

Thanks for all the help and Ideas guys!