Instead of spending time looking for data that someone may have entered, select, copy and paste your exact existing data to a new book and see if you get the same message. I forgot what that was though. If you have an excel sheet stored as excel 97, and use this sheet in office 2016 you may get error like this. I have recommended this question be closed as follows: Split: -- Brian B -- byundt If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. Did this just happen now with spreadsheets successfully used over a period of time? Just wish we could get some better error messages : Best wishes Fredrik Weme Same issue and I'm proposing the solution that worked for me. Our problem is that my boss keeps reinstalling the software at fault, yet swears he doesn't.
I don't know the technical details - but it's like Excel needs a fresh start some. Whenever I try to open the workbook, I get the following error There isn't enough memory to complete this action. Best regards George I'm having this same problem and it just started happening. Sorry, I don't have that count handy. How come Excel was able to create and save this file, but it is not able to open it? Click to participate the survey. Finally, since I'm the one who designed and created it a few months earlier, I recreated the sheet.
Select by referencing the object directly. Where are the files that he's working on saved? Why it was coming up with this memory issue when actually it was a trust centre issue, is beyond me! To increase memory availability, consider: -Using a 64-bit version of Microsoft Excel. This 3 day old copy from the external hardrive is working without problems I wonder if it is a bug in the microsoft software which suddenly triggers this error. The file was originally created in Excel 2010 32-bit. There isn't enough memory to complete this action.
Try using less data or closing other applications. For us, it was to do with trust centre settings. Error handler Dim RunTime1 As Date Sub MacroSwitch Application. Hi Diana4, If you achieve your requirement manually instead of code, will this issue disappear? If no one objects, this question will be closed automatically the way described above. Please get back to us with an update on Excel crashing, we will be happy to help. I have a little issue with excel. Paste as values and rebuild the file from scratch in the new version of Excel you are going to use.
The macro ran fine when creating the workbook and it saved fine. This user is seeing the message more frequently than you're describing. Did you ever find a solution? So I guess be very careful when dealing with large workbooks. However we are affiliated not all but with some software companies and some posts may contain affiliate links. Now I was wondering if its maybe the macro that I am using that switches between 2 sheets at an interval. I'll go days without a restart because it's easier to close my laptop suspend and then resume with all the same stuff open.
I suggest you generate charts and open workbook manually to check whether this issue is related with code or the limitation of Excel. First, how much data is actually in this document. Please reconsider switching to 64-bit Excel. User Alert System provided by - Copyright © 2019 DragonByte Technologies Ltd. A year from now, you'll be glad you made the change. Open the Excel workbook and test.
But in this case that doesn't sound like the problem. Thanks for helping make community forums a great place. Excel will only handle 66K rows of data. Hello David, I realize the inconvenience you are experiencing with Excel. I work with Excel files as large as 40 Mb on a lenovo T420. Seems more related to time system is up and running.
The spreadsheet is not large 231 kb. Click on start and click computer Select Layout, and then click to clear Preview pane. If the above steps fails, start the computer in clean boot and check if the issue persists. For this error, I suggest you refer the link below: Excel 2013 32-bit Performance Articles Released In addition, I suggest you try your steps with Office 2013 64bit in other pcs to check whether it will work. The file was originally created in Excel 2010 32-bit. If issue still persist, start the computer in a clean boot state following instructions mentioned in the article below and verify the result: Note: Ensure to reset the computer in normal mode after troubleshooting.