Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 643
  • Last Modified:

Excel keeps shutting down

Hello Everyone,
I'm having some issues with Excel. It keeps 'not responding' and then will just close or say that the program needs to restart.
 I think the issue is that I'm trying to link different spreadsheets.
 For example I had a worksheet with a data table in it. I copied and pasted the data table into a new worksheet as a 'linked photo'. It worked a few times last week but for some reason today Excel kept shutting down every time I tried to do that. I'm trying to create financial dashboards and I feel like the function would be really helpful if it worked.
Any solutions for this problem?
0
Kaptain1
Asked:
Kaptain1
1 Solution
 
patrickabCommented:
Kaptain1,

I'm not at all sure how to cure the problem. However try copying and 'paste_special' values only.

Patrick
0
 
Rory ArchibaldCommented:
Using linked pictures is extremely resource intensive, so perhaps you are having memory issues. Is this the only thing that causes problems? Also, have you tried a different default printer? (Printer drivers cause all sorts of performance issues in later versions of Excel as they are closely linked to Excel's display)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now