D
D7666
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.
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.