excel issue - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 09-18-2006, 04:54 PM   #1 (permalink)
Junior Techie
Join Date: Apr 2005
Posts: 45
Default excel issue

here at my job we use some rather large excel workbooks. some are huge, some are small. there are no formulas in any of the sheets. They are shared by multiple users on a file server. I have tried a lot of obvious things to try to get these saves to take place quicker with little success. Could a few peopel maybe give me some ideas that might not be really obvious..ie "make sure a bunch of users are not in the file at the same time, or how is your network bandwidth" i need some more indepth possibilities.

Thanks for the help.

pendo007 is offline  
Old 09-18-2006, 06:11 PM   #2 (permalink)
Monster Techie
MrCoffee's Avatar
Join Date: Feb 2006
Location: UK
Posts: 1,858

make the files availiable offline and automatically cache local copies? i'm not sure how well that would work out with multiple users though.

i'll be interested to see if someone comes up with a solution because i really can't see how it can be done.

Intel core I7 920
6GB OCZ platinum 1600
XFX HD4890
Noctua nh-u12p
Corsair HX520
Antec 300
Samsung 1TB F1 Spinpoint
Samsung SM2443BW 24"
MrCoffee is offline  
Old 09-19-2006, 01:57 PM   #3 (permalink)
It's all just 1s and 0s
office politics's Avatar
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics

switch to a database server. ie SQL

development would prolly be expensive and/or take a while.
office politics is offline  
Old 09-19-2006, 02:27 PM   #4 (permalink)
I know things...
wicked23's Avatar
Join Date: Jun 2006
Location: Pennsylvania
Posts: 398

What about switching to an access database. where the backend portion of database lies on server. and the frontend entry portion is on each work station. I currently use this setup for atleast 15 users at one time.
"Research is what I'm doing when it looks like I'm not doing anything" :D

BEER, is it in you?
wicked23 is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 12:18 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.