Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Possible to open large document quickly via network?


  • Please log in to reply

#1
magusbuckley

magusbuckley

    Member

  • Member
  • PipPipPip
  • 625 posts
Hello:

I have an Excel file on my computer that is nearly 150MB in file size. When others access it via the network, it takes a really long time to work with the file. First, after opening the file, Excel shows this scrolling bar stating that its downloading the file, then it opens and another scrolling bar appears stating that it's opening the file. Once in the file, you can quickly and easily make changes. But to save, you're only repeating the process. It takes several minutes to save. I know this is because the file is so large. I'm just wondering if there is a better way to share this data? For example, is it possible to keep a copy of the file on each computer and then have a batch file merge the changes at the end of the day.

This file contains records from A to Z. As a last resort, I could just break up the grouping like A - J, K - Q, R - Z or something like this.


This is Excel 07 and we're running on a 1GB network with very little network traffic.


Any ideas will be greatly appreciated.

Thanks,

Magus

Edited by magusbuckley, 26 December 2009 - 11:28 AM.

  • 0

Advertisements


#2
magusbuckley

magusbuckley

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 625 posts
Maybe I should convert this to an Access Database. This way, I can leave the data on my own computer and put a shortcut to the program on their PCs.

Good idea?

Thanks,

Magus
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP