Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 12th 10, 09:54 AM posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 204
Default Shared book (sorry!) bloating and not disconnecting

We have a shared workbook (which also has some VBA modules) which is shared
over a WAN, and it's causing us some problems:

1. The user appears to be disconnected and has to lose unsaved changes
2. The file thinks it is still connected and shows all the users connected
multiple times - even when they've switched off
3. The file has only about 800 lines (10 or so columns) but is something
silly like 600Mb

Can I sort this out? Is there something I can do to make it work?

Thanks

M


  #2   Report Post  
Old January 12th 10, 04:15 PM posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 89
Default Shared book (sorry!) bloating and not disconnecting

Try going to "Tools", "Share Workbook","Advanced", and then reduce the number
of days the changes are kept.

If you are making lots of changes to the worksheet the file size becomes huge.

If you have users showing mulitple times on the "Editing" page, have
everyone but yourself get out of the shared workbook and then delete the
additional entries.

Irie!


"Michelle" wrote:

We have a shared workbook (which also has some VBA modules) which is shared
over a WAN, and it's causing us some problems:

1. The user appears to be disconnected and has to lose unsaved changes
2. The file thinks it is still connected and shows all the users connected
multiple times - even when they've switched off
3. The file has only about 800 lines (10 or so columns) but is something
silly like 600Mb

Can I sort this out? Is there something I can do to make it work?

Thanks

M



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared book (sorry!) bloating and not disconnecting Michelle Excel Discussion (Misc queries) 1 January 12th 10 04:15 PM
Shared book (sorry!) bloating and not disconnecting Michelle Setting up and Configuration of Excel 1 January 12th 10 04:15 PM
Tracking Changes in Shared Worked Book Eán[_2_] Excel Worksheet Functions 0 November 19th 08 05:16 PM
Macro shared work book Brian Excel Discussion (Misc queries) 2 June 26th 08 12:13 PM
Work book shared kiran Excel Discussion (Misc queries) 8 June 22nd 05 05:47 AM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017