Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Login to participate.

Go Back   TechSpot OpenBoards > OS & Software > Misc. Software & Utilities

Need Help w/ shared Excel spreadsheet

Reply
Bookmark / Share this page
Thread Tools
  #1  
Old 08-06-2006
Newcomer, in training
 
Member since: Jun 2006, 5 posts
Need Help w/ shared Excel spreadsheet

I have an Excel spreadsheet, it's a log of the daily tasks. Now it is constantly being changed throughout out the day. It needs to be edited by multiple people, from multiple workstations. I tried using the share workbook option that Excel has but that didn't work. The problem I had was that after someone would make an edit and save the file it didn't refresh on the screens where the file is always open being displayed. Does anyone know of how I could do this? It doesn't necessarily have to be w/ Excel.
Reply With Quote
  #2  
Old 06-05-2007
Newcomer, in training
 
Member since: Jun 2007, 1 posts
did you ever solve this problem?
Reply With Quote
You can remove this banner by registering, join the TS Community for free.
  #3  
Old 06-06-2007
Newcomer, in training
 
Member since: Jan 2007, 32 posts
Excel spreadsheets are not designed to be used by multiple users simultaneously. Try MS Access or another database.
Reply With Quote
  #4  
Old 06-06-2007
SNGX1275's Avatar
TS Special Forces
 
Location: Rolla, Missouri, USA
Member since: Feb 2002, 8,246 posts
System specs
The post is 10 months old, the dude is probably long gone.

But if the spreadsheet is fairly simple (no macros) you could use Google's spreadsheet thing, it is basically designed for multiple users.
Reply With Quote
  #5  
Old 06-06-2007
halo71's Avatar
TechSpot Addict
 
Location: Augusta, GA.
Member since: Jun 2005, 1,284 posts
Although the original post is kinda old. What we do at work is save the Excel file to a network drive. ANyone that needs access to it, uses it, then makes their saves. Never had any issues with it. Although each workstation user should go into Excel and identify their user ID or whatever (forget where this is in Excel at the moment) so if they are in the spreadsheet and someone else is trying to get into it. The second user will know who they need to ask for access.
Reply With Quote
Reply
Thread Tools

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Need help with forecasting spreadsheet TS | Thomas Misc. Software & Utilities 0 07-10-2006 04:39 PM
RAM (base and shared?) boyevul Other Hardware 5 11-08-2005 10:17 PM
Shared Memory??? omarh1688 Audio and Video 3 06-28-2005 03:29 PM
Pci Usb Only Works With Shared Irq luist CPUs, Chipsets and Mobos 2 02-25-2005 01:29 PM
Shared Memory GoGoGo Other Hardware 4 12-14-2002 08:08 PM


All times are GMT -4. The time now is 03:54 PM.