Filter, Copy Crash

  • Thread starter Thread starter Vickie Bbop
  • Start date Start date
V

Vickie Bbop

I have a spread sheet with 25790 records in it. Everyday
this worksheet is updated and replaced with a new
worksheet. (Number of Records Vary by Day) I sort the
data with two separate column sorts in two different date
fields. I have been successful in doing this for the past
three years and suddenly I get the following error message:

Microsoft Excel cannot creat or use the date range
reference because it is too complex. Try one or more of
the following:
Use data that can be selected in one contigous rectangle
or
Use date from the same sheet.

After clicking OK...I get this:

The instruction at "OX3024AEF" referenced memory
at "OxOOOOOOOO". The memory could not be "read"
Click on ok to terminate the program

Of course it slams shut. I have a brand new computer only
two weeks old...it is a 512 with 88 gig...I run xp
professional operating system ver 5.1 I have both Excel
97 and 2000 and this happeneds no matter what version of
Excel I am working in. Again this has worked in the past
on this new computer and the old one, and with both
versions of Excel. Any ideas?

Thanks,
Vickie
 
Hi Vickie,
I have been successful in doing this for the past
three years and suddenly I get the following error message
Click to expand...

Your file has gained a corruption I'm afraid.

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button, press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer (v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Finally, sometimes a corrupt file that still can be opened can be cured
using this method (XL2000 or up):

- Open the file
- Save-as filetype Webpage
- close the file
- Open the html file
- save-as normal Excel workbook.

Regards,

Jan Karel Pieterse
Excel MVP
 
Thanks so much for your imput. I will try your fixes when
I have a free moment. What I have found is that if I
unhide data and then do the filters I can copy the entire
worksheet. When I past it I have to either hide the extra
columns or delete them. From what I can figure Excel has
a problem with the alloted buffer space...and most of this
space is taken up when I hide columns of data. When I
open the columns even thought there is more data to
copy...the buffer is now free to copy all of the
information.

I have a new problem with the subtotal and filter
features. I am starting to believe that these problems
are created because these macro's were built in earlier
versions on earlier op systems. Now the new and improved
version does not allow these items to work. So much for
an improved version.

Thanks again for your help! I was going crazy trying to
get my work done...it just kept crashing on me!

Regards,

Vickie
-----Original Message-----
Hi Vickie,
I have been successful in doing this for the past
three years and suddenly I get the following error message
Click to expand...

Your file has gained a corruption I'm afraid.

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button, press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer (v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Finally, sometimes a corrupt file that still can be opened can be cured
using this method (XL2000 or up):

- Open the file
- Save-as filetype Webpage
- close the file
- Open the html file
- save-as normal Excel workbook.

Regards,

Jan Karel Pieterse
Excel MVP

.
Click to expand...
 
Back
Top