Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing Excel Work Sheet
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? -- TS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing Excel Work Sheet
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/Microsoft...r-Environment/ This looks good too: http://appdevissues.tripod.com/downl...ication s.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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TSVillanova" wrote: 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? -- TS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing Excel Work Sheet
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. -- TS "ryguy7272" wrote: 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/Microsoft...r-Environment/ This looks good too: http://appdevissues.tripod.com/downl...ication s.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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TSVillanova" wrote: 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? -- TS |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sharing Excel Work Sheet
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/tr...829401033.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/f...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 measu http://www.mvps.org/access/toc.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TSVillanova" wrote: 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. -- TS "ryguy7272" wrote: 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/Microsoft...r-Environment/ This looks good too: http://appdevissues.tripod.com/downl...ication s.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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "TSVillanova" wrote: 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? -- TS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help for sharing a worksheet from a excel sheet | Excel Worksheet Functions | |||
flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007 | Excel Programming | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) |