Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-22-2008, 05:58 PM
=?Utf-8?B?SmltIEFiZWw=?=
 
Posts: n/a
Can some explain the answer I received

I got the folling response to an earlier question but do not know how to find
the article the responder referenced. Can someone tell me where he is
expecting me to find the reference?
I tryed the seach box on the Microsoft.com page but it came back with 0
results found

Thanks

Provided response:

In article <076FA966-0F43-423E-B3C1-5A77AD729081@microsoft.com>,
=?Utf-8?B?SmltIEFiZWw=?= <JimAbel@discussions.microsoft.com> wrote:
>I have a copy of Excel 2003 installed on a server. It is in a share were the
>4 people on out team can access throuh a mapped drive. When any of us open
>the workbook make some changes and attempt to save it we get a messavebox
>that says the disk is full.
>
>This in not true.
>If we save the workbook to our desttop, make the edits save it and copy it
>back to the server they are saved for the next person to see without a
>problem.
>
>This adds a good deal of time to the changes over the month and we would
>like to know ifanyone can tell us why we cannot edit the file directly on the
>server. It contains a data source to a database that populates the workbook
>with some data, if that matters.
>
>Any ideas of why we have this behavior and what we could do so that we can
>simply open the file in place make the changes and then save it , would be
>greatly appreciated.


Reply With Quote
  #2 (permalink)  
Old 07-22-2008, 07:04 PM
Gord Dibben
 
Posts: n/a
Re: Can some explain the answer I received

The only response you got was from Bruce Sinclair and I see no reference to
anything in his reply.

Quoted from Bruce's reply..................................

Are you really close to your disk limit (ie if you saved 2 files the same
size as the one you are talking about, would you get the message on the
second save but not the first ?). The first thing XL does when opening is
create a temp file in the directory where the original is. (copy 1).
When you try to save it, I think it creates a new version, then deletes the
temp file. (copy 2). That it works fine on the desktops is an indicator.
Suggest you have a dung out in the shared directory or ask for more disk
space. :)

End quoted reply................................


Gord Dibben MS Excel MVP


On Tue, 22 Jul 2008 10:58:03 -0700, Jim Abel
<JimAbel@discussions.microsoft.com> wrote:

>I got the folling response to an earlier question but do not know how to find
>the article the responder referenced. Can someone tell me where he is
>expecting me to find the reference?
>I tryed the seach box on the Microsoft.com page but it came back with 0
>results found
>
>Thanks
>
>Provided response:
>
>In article <076FA966-0F43-423E-B3C1-5A77AD729081@microsoft.com>,
>=?Utf-8?B?SmltIEFiZWw=?= <JimAbel@discussions.microsoft.com> wrote:
>>I have a copy of Excel 2003 installed on a server. It is in a share were the
>>4 people on out team can access throuh a mapped drive. When any of us open
>>the workbook make some changes and attempt to save it we get a messavebox
>>that says the disk is full.
>>
>>This in not true.
>>If we save the workbook to our desttop, make the edits save it and copy it
>>back to the server they are saved for the next person to see without a
>>problem.
>>
>>This adds a good deal of time to the changes over the month and we would
>>like to know ifanyone can tell us why we cannot edit the file directly on the
>>server. It contains a data source to a database that populates the workbook
>>with some data, if that matters.
>>
>>Any ideas of why we have this behavior and what we could do so that we can
>>simply open the file in place make the changes and then save it , would be
>>greatly appreciated.


Reply With Quote
  #3 (permalink)  
Old 07-22-2008, 07:07 PM
Gord Dibben
 
Posts: n/a
Re: Can some explain the answer I received

You could browse through this KB search result

http://support.microsoft.com/search/...3comm=1&res=20

Watch for word qrap........all one line


Gord

On Tue, 22 Jul 2008 12:04:36 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>The only response you got was from Bruce Sinclair and I see no reference to
>anything in his reply.
>
>Quoted from Bruce's reply..................................
>
>Are you really close to your disk limit (ie if you saved 2 files the same
>size as the one you are talking about, would you get the message on the
>second save but not the first ?). The first thing XL does when opening is
>create a temp file in the directory where the original is. (copy 1).
>When you try to save it, I think it creates a new version, then deletes the
>temp file. (copy 2). That it works fine on the desktops is an indicator.
>Suggest you have a dung out in the shared directory or ask for more disk
>space. :)
>
>End quoted reply................................
>
>
>Gord Dibben MS Excel MVP
>
>
>On Tue, 22 Jul 2008 10:58:03 -0700, Jim Abel
><JimAbel@discussions.microsoft.com> wrote:
>
>>I got the folling response to an earlier question but do not know how to find
>>the article the responder referenced. Can someone tell me where he is
>>expecting me to find the reference?
>>I tryed the seach box on the Microsoft.com page but it came back with 0
>>results found
>>
>>Thanks
>>
>>Provided response:
>>
>>In article <076FA966-0F43-423E-B3C1-5A77AD729081@microsoft.com>,
>>=?Utf-8?B?SmltIEFiZWw=?= <JimAbel@discussions.microsoft.com> wrote:
>>>I have a copy of Excel 2003 installed on a server. It is in a share were the
>>>4 people on out team can access throuh a mapped drive. When any of us open
>>>the workbook make some changes and attempt to save it we get a messavebox
>>>that says the disk is full.
>>>
>>>This in not true.
>>>If we save the workbook to our desttop, make the edits save it and copy it
>>>back to the server they are saved for the next person to see without a
>>>problem.
>>>
>>>This adds a good deal of time to the changes over the month and we would
>>>like to know ifanyone can tell us why we cannot edit the file directly on the
>>>server. It contains a data source to a database that populates the workbook
>>>with some data, if that matters.
>>>
>>>Any ideas of why we have this behavior and what we could do so that we can
>>>simply open the file in place make the changes and then save it , would be
>>>greatly appreciated.


Reply With Quote
  #4 (permalink)  
Old 07-22-2008, 10:25 PM
=?Utf-8?B?SmltIEFiZWw=?=
 
Posts: n/a
Re: Can some explain the answer I received

there is 50GB of space available so after some more research it looks like I
was going in the wrong direction. With some trail and error I have found
that we are encountering the issue when the workbook reachs a larger size
when the failure occurs that first throws up a message that says

Excel is unable to load the cached records for one or more PivotTable
reports. You will need to refresh those report before they can be used again.
"Gord Dibben" wrote:

after clicking ok on the dialog the messagebox pops up stating that the Disk
is full and then clicking ok the message

Document not saved. comes up and lastly a message that states

Windows was unable to save all the data for the file [path\filename].
The data has been lost. This error may be caused by a failure of your
computer hardware or network connection. Please try to save this file...

So it now looks like it is some kind of timeout issue.. I'll go back to the
postings and search timeouts or saving large files to the network drive and
see what I can find.


> You could browse through this KB search result
>
> http://support.microsoft.com/search/...3comm=1&res=20
>
> Watch for word qrap........all one line
>
>
> Gord
>
> On Tue, 22 Jul 2008 12:04:36 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:
>
> >The only response you got was from Bruce Sinclair and I see no reference to
> >anything in his reply.
> >
> >Quoted from Bruce's reply..................................
> >
> >Are you really close to your disk limit (ie if you saved 2 files the same
> >size as the one you are talking about, would you get the message on the
> >second save but not the first ?). The first thing XL does when opening is
> >create a temp file in the directory where the original is. (copy 1).
> >When you try to save it, I think it creates a new version, then deletes the
> >temp file. (copy 2). That it works fine on the desktops is an indicator.
> >Suggest you have a dung out in the shared directory or ask for more disk
> >space. :)
> >
> >End quoted reply................................
> >
> >
> >Gord Dibben MS Excel MVP
> >
> >
> >On Tue, 22 Jul 2008 10:58:03 -0700, Jim Abel
> ><JimAbel@discussions.microsoft.com> wrote:
> >
> >>I got the folling response to an earlier question but do not know how to find
> >>the article the responder referenced. Can someone tell me where he is
> >>expecting me to find the reference?
> >>I tryed the seach box on the Microsoft.com page but it came back with 0
> >>results found
> >>
> >>Thanks
> >>
> >>Provided response:
> >>
> >>In article <076FA966-0F43-423E-B3C1-5A77AD729081@microsoft.com>,
> >>=?Utf-8?B?SmltIEFiZWw=?= <JimAbel@discussions.microsoft.com> wrote:
> >>>I have a copy of Excel 2003 installed on a server. It is in a share were the
> >>>4 people on out team can access throuh a mapped drive. When any of us open
> >>>the workbook make some changes and attempt to save it we get a messavebox
> >>>that says the disk is full.
> >>>
> >>>This in not true.
> >>>If we save the workbook to our desttop, make the edits save it and copy it
> >>>back to the server they are saved for the next person to see without a
> >>>problem.
> >>>
> >>>This adds a good deal of time to the changes over the month and we would
> >>>like to know ifanyone can tell us why we cannot edit the file directly on the
> >>>server. It contains a data source to a database that populates the workbook
> >>>with some data, if that matters.
> >>>
> >>>Any ideas of why we have this behavior and what we could do so that we can
> >>>simply open the file in place make the changes and then save it , would be
> >>>greatly appreciated.

>
>

Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Excel


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

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



All times are GMT. The time now is 11:26 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Personal Loans | Mortgages | Mortgages | Credit Card | Books



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109