resources

Apologies if I’m in the wrong forum please redirect me. Large (~300mb) .xlsm project ridiculously slow for months (½ hour just to load). Finally tracked it down I think to somehow a complex array formula referencing several sheets mistakenly copied into 200,000+ cells. Now even trying to delete...

Hi , I am planning to create a dashboard which will help executives look at how many projects we can start with respect to resources available / freed up. I have a list of projects with Resources required and i also have the number of resources required for each projects. Can someone please...

Hello!! I am hoping you excel genius' can help a girl out!!! I have tried to explain below my situation. Please offer any help you think you can! Much appreciated. TAB 1: Data is entered manually in cells B2:J3 The data in the cells is as follows: AA: BB: CC, CC Where AA is the Location of the...

Hi all, Apologies for the long post. I maintain a relatively large workbook (5.91mb) that's used by the sales team within the company I work in. The company has expanded, and as such, I've had to add in calculations to the workbook, and ever since, the sales team have been receiving the...

"Choose less data or close other applications. Continue without Undo?" Been Googling this error and have not yet found a solution. It is a very simple workbook. I have one tab with raw data, and a 2nd tab that pulls data from the 1st tab and formats it. I also use sub-strings, "find", etc. as...

Hello. We have old computers in my company. Most have office 2010. I'm fighting with sysadmins that they need to install office 2016, but they argue that new office would eat lots of resources and this old PCs would be laggy. I tried to find some info about resources consumption of different...

Hello, I have a worksheet with a lot of information, and I want to make another one in the same file with some concise information, but when data is changed in the first worksheet to automatically change in the second one. I found the following sollution: copy the respective rows and paste...

Hi there, This forum is amazing! So many great answers - I'm hoping someone will be able to help with this one: There are some slicers connected to a pivot table summarizing a local table (about 5000 records - nothing too big). In excel 2010, when I hover over the slicers it gives the error...

Hi, we have nice tracking file in excel at work. However that is also the one file that gives various errors. It does so on all computers, both when file is on network, and also if we try it with a local copy on Cdrive. When opening the file it warns that "excel cannot complete the task with...

I have Excel 2010, and I've never had that kind of issues in previous Excel versions. It doesn't matter the size of the file, if I use macros or not, this message appears if I want to create a new tab... or open a file, this message appears, forcing me to close everything, and open again, which...

Im running a Dell XPS latest processor, 32gb of ram and a solid state hard drive. When I try to open an excel file, 400mb, Im getting a critical error that says I don't have enough resources to open the file. My hardware profile is strong, is there a system resource file or swap files or...

Ugh, I can't seem to get my head wrapped around this problem. I am trying to get a list of people on projects based on if they have scheduled time on the project. My data is set up in the example below(actual table is >900 people and >75 projects): <tbody> ProjectA ProjectB ProjectC...

Hi everyone. First post. I have an existing workbook that is quite complex. It is an .xls version. One of the formulas is a sumproduct. This workbook all works fine, even when opened with Excel 2010. I tried creating a new workbook but when I used the sumproduct formula it says that it has run...

I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Example Source table and Target table in attached file. Target: Need a Excel macro to Generate a new Worksheet with 'Task' wise Report as mentioned below...

Hi All, I have 16GB of RAM and I'm only using 4.5GB currently and only 10% CPU. Has anyone encountered this error message before? [Not enough resources in Excel to perform task]. Any solutions/settings to pursue? Thanks m

Hi everyone. Quick question. I am trying to use VBA to subtotal a relatively small amount of information, and on one (out of a hundred or so jobs) I am failing and getting an error message saying that Excel does not have enough resources to complete the task. (And I've tried this on many very...

Hello Forum, When comparing resource needs; does a table of the same size as a list use the same memory?

I have a macro that runs for approximately 90 Sales Rep files. The macro itself runs fairly quick but I have noticed that I am unable to do anything while the macro is running due to Excel Automatic Calculate will use 100% of the CPU Usage throughout the macro. I have to calculate the...

Hello, Is there a way I can spring a message and exit a routine if Excel receives an out of memory error? I have a routine which does a lot of calculation and importing data via ODBC and on occasion I will get ODBC error System Resources Exceeded- The fix is pretty easy, I just close...

Quick Summary: Is it possible to simulate closing Excel and opening Excel from within a workbook using a Macro? Some Details: Basically I have a workbook which runs and when it is done I see that the memory use (in the Ctrl+alt+del system tasks section) for Excel is at 1,250MB. It won't let...