Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very large database (600k rows, 40 columns in xlsx) | Excel Discussion (Misc queries) | |||
In excel what does a file ending with .xlsx mean? | Excel Discussion (Misc queries) | |||
How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
How do I open excel 2008 file | Excel Discussion (Misc queries) | |||
can't open .xlsx file in excel 2007 | Excel Discussion (Misc queries) |