Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2013, 05:40 PM
BobBridges's Avatar
BobBridges BobBridges is offline Excel to Access to Excel for report automation Windows 7 64bit Excel to Access to Excel for report automation Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default


Oh, you really did mean "share" in the complete sense. I'm inclined to think you're right, that if you want updates to be placed in B even while people are using B, you'd have to make it a database. It doesn't have to be Access—I mean, it could be Oracle or whatever—but you probably can't do that in Excel. Excel complains about just two people trying to have write access to the same workbook, much less 12.

Now, if you're really in love with the idea of doing it in Excel, then there are probably ways to get fairly quick updates. Any changes could be written to a file, and then as soon as the workbook is free—not being updated by anyone—a program could run that would load the changes into the workbook, so they'd be available to the next person who opened it. I'm not sure how that would be done, but I can think of a couple possibilities. But it wouldn't be true concurrent sharing. It's the best I know how to do, though. Sound interesting?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to Access to Excel for report automation Projects Cash Flow Report in Excel not creating monthly data gardwr Project 2 09-02-2013 09:10 AM
field controls for automation via excel ajetrumpet Word 0 07-13-2013 09:48 PM
Excel to Access to Excel for report automation Inexplicable automation errors in Word and Excel RichardP Word VBA 4 08-16-2012 07:38 PM
Automation Word-Excel stephen_pen Mail Merge 0 09-22-2011 05:17 PM
Excel to Access to Excel for report automation Word, Excel automation Paul-NYS Office 3 06-29-2011 01:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft