A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Disk Full" try to save Excel 2007 file



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2009, 05:01 PM posted to microsoft.public.office.misc
Dennis
external usenet poster
 
Posts: 1,222
Default "Disk Full" try to save Excel 2007 file

I am trying to save a large Excel file but continue getting "Disk Full"
errors even though I have 7.1GB, 7.7GB and 80GB on the three different local
harddrives. The csv file from which this is created has 162K rows and 100
cols (I don't know how large the xlsx file will be as I've not successfully
save it yet). However, I have successfully save a similar file of 102K rows
and 100 cols (73MB xlsx file). I have also tried creating a small xlsx file
and overwriting it to no avail.

Is there some restriction to the size of files that can be saved? An idea
what I need to do to be able to save these files (this has happened twice
before and will be neccessary again)?

Thanks,
Dennis
  #2  
Old November 16th, 2009, 05:34 PM posted to microsoft.public.office.misc
LVTravel
external usenet poster
 
Posts: 1,384
Default "Disk Full" try to save Excel 2007 file


"Dennis" wrote in message
...
I am trying to save a large Excel file but continue getting "Disk Full"
errors even though I have 7.1GB, 7.7GB and 80GB on the three different
local
harddrives. The csv file from which this is created has 162K rows and 100
cols (I don't know how large the xlsx file will be as I've not
successfully
save it yet). However, I have successfully save a similar file of 102K
rows
and 100 cols (73MB xlsx file). I have also tried creating a small xlsx
file
and overwriting it to no avail.

Is there some restriction to the size of files that can be saved? An idea
what I need to do to be able to save these files (this has happened twice
before and will be neccessary again)?

Thanks,
Dennis


If the drive is formatted as a FAT 32 drive there is a 4 GB file size limit
but with the size of the Excel file I don't think you should be exceeding
that size limit. If the file size does exceed the 4 GB limit it will give a
message like you are getting. NTFS format there is no limit to the file
size. Check the format of the hard drive where you are saving. Right click
on drive letter in My computer (or Computer in Vista) and then left click
properties for the drive format type.

Can't remember if Excel itself has a limit to the spreadsheet that would
mimic the out of hard drive space. I am sure that someone with more Excel
experience than I have will post if there is anything like that.

One other thought is the drive with 7.1 and 7.7 GB of free space. If your
temporary files are being written to them during the spreadsheet creation it
may very well be using enough of the free space that the output file can not
be written successfully. Again, just a thought and may be off base here.
Try to set your temporary files to the 80 GB free drive.

  #3  
Old November 16th, 2009, 08:16 PM posted to microsoft.public.office.misc
DL[_3_]
external usenet poster
 
Posts: 3,440
Default "Disk Full" try to save Excel 2007 file

In addition your C (win) drive requires a minimum of 15% free space for
efficient useage of win

"Dennis" wrote in message
...
I am trying to save a large Excel file but continue getting "Disk Full"
errors even though I have 7.1GB, 7.7GB and 80GB on the three different
local
harddrives. The csv file from which this is created has 162K rows and 100
cols (I don't know how large the xlsx file will be as I've not
successfully
save it yet). However, I have successfully save a similar file of 102K
rows
and 100 cols (73MB xlsx file). I have also tried creating a small xlsx
file
and overwriting it to no avail.

Is there some restriction to the size of files that can be saved? An idea
what I need to do to be able to save these files (this has happened twice
before and will be neccessary again)?

Thanks,
Dennis



 




Thread Tools
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 On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.