ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Unexpected closure of Excel (https://www.excelbanter.com/links-linking-excel/108010-unexpected-closure-excel.html)

Chris A

Unexpected closure of Excel
 
I have a 23Mb Spreadsheet which has links to various other sheets and
PowerPoint Presentations. When I select certain sheets to create a copy, the
following occurs

1. Book 1.xls created

2. reading data.......

3. calculating

but at 15% complete Excel shuts down with no warning or error message. if 3,
4 or 5 sheets are open which are not connected, they also shut down w/o
saving or promptinig for a save.

I can create a copy with some sheets but as soon as I include other sheets
the problem appears. Memory does not seem to be an issue, nor which computer
on the network I use. Network profiles have been reset, no good, even a roll
back to a copy of the sheet that worked, but that now does not work..

Something, somewhere is conflicting or is corrupted, any ideas
--
Chris A
Frustrated Excel user

Ken Wright

Unexpected closure of Excel
 
Have you tried 'Open and Repair'?

Also try saving as a .htm file and then back to a .xls file (called
RoundTripping) as this can often fix corruptions.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Chris A" wrote in message
...
I have a 23Mb Spreadsheet which has links to various other sheets and
PowerPoint Presentations. When I select certain sheets to create a copy,
the
following occurs

1. Book 1.xls created

2. reading data.......

3. calculating

but at 15% complete Excel shuts down with no warning or error message. if
3,
4 or 5 sheets are open which are not connected, they also shut down w/o
saving or promptinig for a save.

I can create a copy with some sheets but as soon as I include other sheets
the problem appears. Memory does not seem to be an issue, nor which
computer
on the network I use. Network profiles have been reset, no good, even a
roll
back to a copy of the sheet that worked, but that now does not work..

Something, somewhere is conflicting or is corrupted, any ideas
--
Chris A
Frustrated Excel user





All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com