Guest David Posted August 21, 2007 Posted August 21, 2007 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?
Guest Mathieu CHATEAU Posted August 21, 2007 Posted August 21, 2007 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? >
Guest David Posted August 22, 2007 Posted August 22, 2007 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? >> >
Guest Mathieu CHATEAU Posted August 22, 2007 Posted August 22, 2007 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? >>> >> > >
Guest David Posted August 23, 2007 Posted August 23, 2007 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? >>>> >>> >> >> >
Recommended Posts