Sharing Excel Work Sheet

  • Thread starter Thread starter TSVillanova
  • Start date Start date
T

TSVillanova

I would like to have real time sharing on one of our excel work sheets. The
sharing feature that excel has is not very good. Especially when sorting
columns and entering comments. I was informed that Access might be one
option. Does anyone know how bet to approach this?
 
Tools > Share Workbook > Allow is a great concept, but it never seems to
work. As I recall, theoretically you can have 255 users. In practice, it is
much less, like 2-3. Also, if the workbook is close to 1MB or over,
performance is very slow and when I've used this feature in the past, the
Workbooks often became corrupted. I'll tell you from experience, stay away
from it at all costs. A great alternative is MS Access. The learning curve
can be steep, but it's worth it.

Check this out:
http://www.aspfree.com/c/a/Microsof...ess-Application-for-a-Multi-user-Environment/

This looks good too:
http://appdevissues.tripod.com/down...er Microsoft Access Database Applications.pdf

Set up Access so that you have a split database; backend database
on the server and independent front end databases on each person's machine
with the forms, reports static data etc.

Excel is an amazing tool, but Access is much better for some things. I
started learning Access when I outgrew Excel, and basically had to do some
things that Excel just wasn't designed to do. If you have more questions
post back, or you can send me an email and I can send you some sample files
to help you get started.

HTH,
Ryan---
(e-mail address removed)
 
So Access is the data base from which you can use Excel spread sheets to
obtain data from?

This sounds like you almost need to be a programmer to do this.
 
Well, Access is definitely a database. Access integrates with Excel quite
nicely, because they are both products of Microsoft. You can send/receive
data from Access to Excel and from Excel to Access. You can use Excel as a
front end and Access as a backend. However, I'd recommend learning the ins
and outs of Access, and just use that for the project you described above.
It will take much more effort to do all the coding to use Excel as the
interface and warehouse the data in Access Tables.

If you have some free time this weekend, take a look at these videos:
http://datapigtechnologies.com/AccessMain.htm

Also, check out these tutorials:
http://office.microsoft.com/en-us/training/CR061829401033.aspx

Perfect for you:
http://www.granite.ab.ca/access/splitapp/index.htm

Also:
http://www.accessmonster.com/

Good Stuff:
http://www.access-freak.com/tutorials.html#Tutorial01

Good Samples:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=1&PN=1

More Samples:
http://www.fontstuff.com/access/

This site is great!!
http://www.databasedev.co.uk/

One more for good measure:
http://www.mvps.org/access/toc.htm

HTH,
Ryan---
 
Back
Top