performance

Hello Everybody, I am seeking for answer about Performance of Power BI. Originally I had 2GB Access database, converted into Power BI, with some other small tables it give me 130MB PBIX. After creating the model I realized it is too slow, does not pass "3 sec" test. I did following steps: 1...

Excel 2010, 32 bit OS, dual core, 4G RAM One of our team has a fairly large spdsht that has one page with a large number of conditional formats applied to it (the range containing the formats is currently 66 columns and 1655 rows, with a conditional format for every column). His process is to...

So I have created this MACRO for work, to ensure everything is getting charged right. Well I would like it to run through pretty much the entire database data for 2 years, I can not get it to last that long. I can copy the data to a separate spreadsheet and run the macro in chunks, but I would...

Regarding how SUMIF recalculates...I have a large worksheet with many grouped rows (1600+) and 115k sumif formulas with a pretty crazy dependency tree. Each time an input changes or a group of rows is expanded the worksheet recalculates and it takes quite some time. Assuming a sumif is...

Hi all, This is my 1st post here and I come in the hope one of you, Excel guru guys (or girl) can make sense of this! I've got this rather ugly code running on Excel 2007 and there it can go through 60.000 rows in less than 2 minutes. Try it on Excel 2013 and bang, it takes FOREVER... to the...

Hi Guys I was wondering if any of you experts could tell me how to create a slider scale type bar chart if at all possible. I'm due to produce my monthly energy reports at work and want to make them look a little swankier by updating and refreshing the overall format a little. A portion of my...

I have a large data set of about 375,000 rows by about 6 columns and I have a macro that does a few calculations on the dataset and appends two additional columns for each row. The calculations are pretty mild (basic division, multiplication and a sqrt function). Ultimately, the macro works as...

Here's a really strange one - I have a set of macros that perform simple show/hide operations on a set of columns. Here's one of these macros, the others are very similar (I'm not including the code of all subs/functions being called because I reckon it's not relevant, but will be glad to do so...

I've written the UDF (see below) and I'm using in my spreadsheet in one column across 3,000 rows with this call: =ConcatRangeIF(BB6,$BB$6:$BB$3000,$BG$6:$BG$3000," >") Now, when I first use it, Excel takes about 20-30 seconds to calculate it. But, later as I manipulate data on the page...

Hi I’m just asking if anyone has a good template they can share for tracking share investment performance that would support multiple purchases, sales, dividend reinvestment and dividends etc over multiple years? All info greatly appreciated

Hi, I have a lot of week over week measures in my model. At the moment the way those are implemented is as follows: MeasureWoW := ([Measure]-[MeasurePrevWeek])/[MeasurePrevWeek] MeasurePrevWeek := Calculate([Measure],Dateadd(calendar[Date],-7,Day)) Since these calculations are the...

I have a excel with column "A" containing non-formatted html data. To format this data, I am following the below steps: 1) Take the non-formatted html data from first cell and paste it on Internet explorer and paste the formatted text from html page to excel column "E" (HTML Text with tags to...

I've created a VBA macro to take data from a sharepoint list and convert it into a format where i'm able to utilise a pivot table to display the data. The macro itself runs fine albeit a little slow and was wondering if anyone could help me perform some performance tuning, i'm not looking for...

Hello people, I created some time ago a spreadsheet that my team uses to keep a record of some work that we do. The basic format is that each task takes up a row of the spreadsheet, with an Id, Title etc and a cell containing any notes that people may add to the task. This notes field has text...

I am writing a sub that has 17 calls to different subs and functions. I broke it up in this way because it was easier to write smaller pieces since a lot of actions are repeated (e.g., copying and renaming worksheets) and it was easier to control the flow I diagrammed in advance. Some calls are...

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

I'm experiencing this for the first time: I'm using Excel to import about 20,000 web pages. I've noticed that Excel started off flying: 1 page every 3 seconds. Around 1000 it was noticeably slower. Around 2000 it was pulling 1 page every 30 seconds. One thing I've been doing is stop the macro...

Hi Folks, I am using Excel Mac 2011 and have a rather large macro that takes information from a very large global worksheet (10,000 rows) and creates approx 100 new worksheets. It's mostly nested for loops, nothing too complex. The overall performance of the Macro is fine, taking around 10...

Hi all, Thanks for all your help in the past week. My excel is nearly completed; however, even without the data, the size is about 3MB, and I guess it is all the formulae. Question: Whenever I enter data, it starts to re-calculate the whole thing, is there any way that it would ONLY do the...