I've found a rather odd problem with a large ... well huge ... XLSX
file.

I'm not sure if this ought to go under Excel or Vista ... but for now
its here.

The file is a single XLSX worksheet 7 columns wide but 887022 rows
deep and is 38.103 MB size. It is a simple file of text, no cell has
more than 10 characters, there are no macros, no formula, no graphics,
no images, no formatted cells other than default, nothing, just 7 x
887022 cells with ASCII text and number.

Excel does all I need it to. It works. I can search and sort and so
on, thats all I need within Excel.

Except I can't move the file around. I've tried this after reboots,
power cycle restarts everything. I've tried opening file in excel,
closing it, opening it, etc etc. every sequence.

I've even deleted it, shutdown, and re-created it. Its easy to do, the
data comes from a single tab delimited .TXT file, it converts first
go every timeto XLSX. But then the same fault.

The .xlsx file I cannot move, cut, copy, paste using explorer, not to
another folder, partition or USB stick or CDROM.

The .txt file is also 38 MB - that works - so its not size or disk
space or anything like that.

Manipulating larger and even much larger files is something I do all
the time, but this has baffled me.

It is almost as if the XLSX file is somehow locked into the folder in
which it is created. I have created it again from new in a different
folder, same problem. Can't move / cut / copy / paste it.

File properties shows nothing unusual, its not hidden or read only or
anything.

In explorer, can command select, and command copy, but wherever you go
to paste, PC sits on a continuous ''preparing to copy'' popup box.
X'ing the box window or hitting cancel kills the job immediately,
whether after 60 secs or 60 mins, the result is the same.

I can't find anything obvious in MS Knowledgebase either.

Any ideas ?

I'm baffled.

--
Nick

On Apr 8, 10:02*pm, D7666 wrote:


Errrr typo in subject.


That should be Excel 2007 not 2008.



--
Nick

Sounds like a Vista problem to me. Lots of complaints out there...

http://www.google.com/search?q=can%2....mozilla:en-US

--
Jim Cone
Portland, Oregon USA
D582




"D7666" wrote in message
...
I've found a rather odd problem with a large ... well huge ... XLSX
file.
I'm not sure if this ought to go under Excel or Vista ... but for now
its here.
The file is a single XLSX worksheet 7 columns wide but 887022 rows
deep and is 38.103 MB size. It is a simple file of text, no cell has
more than 10 characters, there are no macros, no formula, no graphics,
no images, no formatted cells other than default, nothing, just 7 x
887022 cells with ASCII text and number.

Excel does all I need it to. It works. I can search and sort and so
on, thats all I need within Excel.
Except I can't move the file around. I've tried this after reboots,
power cycle restarts everything. I've tried opening file in excel,
closing it, opening it, etc etc. every sequence.

I've even deleted it, shutdown, and re-created it. Its easy to do, the
data comes from a single tab delimited .TXT file, it converts first
go every timeto XLSX. But then the same fault.
The .xlsx file I cannot move, cut, copy, paste using explorer, not to
another folder, partition or USB stick or CDROM.

The .txt file is also 38 MB - that works - so its not size or disk
space or anything like that.
Manipulating larger and even much larger files is something I do all
the time, but this has baffled me.

It is almost as if the XLSX file is somehow locked into the folder in
which it is created. I have created it again from new in a different
folder, same problem. Can't move / cut / copy / paste it.

File properties shows nothing unusual, its not hidden or read only or
anything.
In explorer, can command select, and command copy, but wherever you go
to paste, PC sits on a continuous ''preparing to copy'' popup box.
X'ing the box window or hitting cancel kills the job immediately,
whether after 60 secs or 60 mins, the result is the same.
I can't find anything obvious in MS Knowledgebase either.
Any ideas ?
I'm baffled.
--
Nick

On Apr 8, 10:46*pm, "Jim Cone" wrote:

Sounds like a Vista problem to me. *Lots of complaints out there...

http://www.google.com/search?q=can%2...ie=utf-8&oe=ut...


I'm not so sure.

I am aware of those vista ''problems'' but I 've never found them.

I routinely move numbers of large files like this and I've never ever
had a single problem in 2.5 years of Vista on 3 machines.

The largest file that I move / copy / use is 1.3 GB, thats a zip file,
while I have a large number of MP3 files that range from 20 to 150 MB
and I have not one single problem, and a smaller number of PDF, PPT,
MOV, AVI, WAV, files, as well as ISO, TAR, etc that I handle.

Not one single problem with any of them.

Just with this XLXS file. Thats really why I put the question under
excel rather than vista.

--
Nick