File Advice

  • Thread starter Thread starter David
  • Start date Start date
D

David

Guest
I have posted this in the Excel forum but no joy. I was wondering if you
guys had any ideas relating to this

We have an excel spreadsheet on a network drive. One user accesses it in the
head office and other accesses it over VPN connections. Sometimes when
people access it and someone else has it open they don't get the popup to
say that it is already open. Is there some setting for this that needs
altering on the file? Also why would you get disk full errors when you try
and save changes although their are no quotas or limits for any user?
 
Re: File Advice

hello,

you can put the excel file in "shared" mode:

How to use shared workbooks with different versions of Excel
http://support.microsoft.com/kb/269860/en-us

--
Cordialement,
Mathieu CHATEAU
http://lordoftheping.blogspot.com


"David" <wibble@wobble.com> wrote in message
news:e0QwNhA5HHA.5724@TK2MSFTNGP05.phx.gbl...
>I have posted this in the Excel forum but no joy. I was wondering if you
>guys had any ideas relating to this
>
> We have an excel spreadsheet on a network drive. One user accesses it in
> the
> head office and other accesses it over VPN connections. Sometimes when
> people access it and someone else has it open they don't get the popup to
> say that it is already open. Is there some setting for this that needs
> altering on the file? Also why would you get disk full errors when you try
> and save changes although their are no quotas or limits for any user?
>
 
Re: File Advice

Thanks for the reply. We have tried that but when it is enabled in shared
workbook mode access to that files is drastically slow. Any thoughts on what
could be causing it that?

"Mathieu CHATEAU" <gollum123@free.fr> wrote in message
news:u%23dW6jC5HHA.1208@TK2MSFTNGP03.phx.gbl...
> hello,
>
> you can put the excel file in "shared" mode:
>
> How to use shared workbooks with different versions of Excel
> http://support.microsoft.com/kb/269860/en-us
>
> --
> Cordialement,
> Mathieu CHATEAU
> http://lordoftheping.blogspot.com
>
>
> "David" <wibble@wobble.com> wrote in message
> news:e0QwNhA5HHA.5724@TK2MSFTNGP05.phx.gbl...
>>I have posted this in the Excel forum but no joy. I was wondering if you
>>guys had any ideas relating to this
>>
>> We have an excel spreadsheet on a network drive. One user accesses it in
>> the
>> head office and other accesses it over VPN connections. Sometimes when
>> people access it and someone else has it open they don't get the popup to
>> say that it is already open. Is there some setting for this that needs
>> altering on the file? Also why would you get disk full errors when you
>> try
>> and save changes although their are no quotas or limits for any user?
>>
>
 
Re: File Advice

hello,

what is the size of the file and office version ?
http://office.microsoft.com/en-us/excel/HA010130571033.aspx
What if your project outgrows the shared workbook?

Over time, if you keep change history continuously, your shared workbook can
become so large that it's slow to load. If your worksheet is becoming too
large to use efficiently, find information in, and maintain; if managing
user access becomes time consuming for the number of users of the workbook;
or if you or users are constantly having to resolve conflicts, consider
converting the workbook to a Microsoft Access database. Access is a good
choice for any worksheet list that has become so large and complex that it's
difficult to maintain, because Access gives you true multiuser capability
and security features along with several options that can help you to
maintain data accuracy and integrity. Access is designed to allow you to
organize large amounts of data for efficient storage and retrieval.

--
Cordialement,
Mathieu CHATEAU
http://lordoftheping.blogspot.com


"David" <wibble@wobble.com> wrote in message
news:OhvhyvI5HHA.1212@TK2MSFTNGP05.phx.gbl...
> Thanks for the reply. We have tried that but when it is enabled in shared
> workbook mode access to that files is drastically slow. Any thoughts on
> what could be causing it that?
>
> "Mathieu CHATEAU" <gollum123@free.fr> wrote in message
> news:u%23dW6jC5HHA.1208@TK2MSFTNGP03.phx.gbl...
>> hello,
>>
>> you can put the excel file in "shared" mode:
>>
>> How to use shared workbooks with different versions of Excel
>> http://support.microsoft.com/kb/269860/en-us
>>
>> --
>> Cordialement,
>> Mathieu CHATEAU
>> http://lordoftheping.blogspot.com
>>
>>
>> "David" <wibble@wobble.com> wrote in message
>> news:e0QwNhA5HHA.5724@TK2MSFTNGP05.phx.gbl...
>>>I have posted this in the Excel forum but no joy. I was wondering if you
>>>guys had any ideas relating to this
>>>
>>> We have an excel spreadsheet on a network drive. One user accesses it in
>>> the
>>> head office and other accesses it over VPN connections. Sometimes when
>>> people access it and someone else has it open they don't get the popup
>>> to
>>> say that it is already open. Is there some setting for this that needs
>>> altering on the file? Also why would you get disk full errors when you
>>> try
>>> and save changes although their are no quotas or limits for any user?
>>>
>>
>
>
 
Re: File Advice

Thats for getting back to me. The file is 2Mb and everyone is using Excel
2003 to access it. My ideal situation would be an access database but
unfortunately i wouldn't know where to start to write something like that.

"Mathieu CHATEAU" <gollum123@free.fr> wrote in message
news:uToG0VO5HHA.4476@TK2MSFTNGP06.phx.gbl...
> hello,
>
> what is the size of the file and office version ?
> http://office.microsoft.com/en-us/excel/HA010130571033.aspx
> What if your project outgrows the shared workbook?
>
> Over time, if you keep change history continuously, your shared workbook
> can become so large that it's slow to load. If your worksheet is becoming
> too large to use efficiently, find information in, and maintain; if
> managing user access becomes time consuming for the number of users of the
> workbook; or if you or users are constantly having to resolve conflicts,
> consider converting the workbook to a Microsoft Access database. Access is
> a good choice for any worksheet list that has become so large and complex
> that it's difficult to maintain, because Access gives you true multiuser
> capability and security features along with several options that can help
> you to maintain data accuracy and integrity. Access is designed to allow
> you to organize large amounts of data for efficient storage and retrieval.
>
> --
> Cordialement,
> Mathieu CHATEAU
> http://lordoftheping.blogspot.com
>
>
> "David" <wibble@wobble.com> wrote in message
> news:OhvhyvI5HHA.1212@TK2MSFTNGP05.phx.gbl...
>> Thanks for the reply. We have tried that but when it is enabled in shared
>> workbook mode access to that files is drastically slow. Any thoughts on
>> what could be causing it that?
>>
>> "Mathieu CHATEAU" <gollum123@free.fr> wrote in message
>> news:u%23dW6jC5HHA.1208@TK2MSFTNGP03.phx.gbl...
>>> hello,
>>>
>>> you can put the excel file in "shared" mode:
>>>
>>> How to use shared workbooks with different versions of Excel
>>> http://support.microsoft.com/kb/269860/en-us
>>>
>>> --
>>> Cordialement,
>>> Mathieu CHATEAU
>>> http://lordoftheping.blogspot.com
>>>
>>>
>>> "David" <wibble@wobble.com> wrote in message
>>> news:e0QwNhA5HHA.5724@TK2MSFTNGP05.phx.gbl...
>>>>I have posted this in the Excel forum but no joy. I was wondering if you
>>>>guys had any ideas relating to this
>>>>
>>>> We have an excel spreadsheet on a network drive. One user accesses it
>>>> in the
>>>> head office and other accesses it over VPN connections. Sometimes when
>>>> people access it and someone else has it open they don't get the popup
>>>> to
>>>> say that it is already open. Is there some setting for this that needs
>>>> altering on the file? Also why would you get disk full errors when you
>>>> try
>>>> and save changes although their are no quotas or limits for any user?
>>>>
>>>
>>
>>
>
 
Back
Top