Got a support call from an associate who is receiving the message "Excel cannot complete this task with available resources. Choose less data or close other applications" when trying to Insert Columns.
I am familiar with this issue from previous versions and have tried the following things to correct it, but to no avail. If you have any other suggestions it would be greatly appreciated:
Here's what we've tried:
1. Closed all other open applications and re-opened the Excel File.
Pressed Ctrl-End to see where the active area ends. It ends in MC (2 rows from the bottom of the worksheet). Tried deleting columns from MC through the end of the worksheet. Got same error message
2. Tried clearing All formats/data for the cells to the right of column MC - same issue
3. Tried re-saving the file under a different name. Reopened the file and tried again with no success.
3. Went to the Visual Basic Editor for the active sheet ant in the Immediate Windows typed ActiveSheet.UsedRange to try to reset the Active area. When we pressed ENTER in the VBE window we got the "Microsoft Excel has Encountered an Error" message and the worksheet closed.
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…