size

Hi, We have a data around 300k rows and 20 columns and then a power-pivot report and the file size is like 40MB, I tried the data model and move power-pivot report into a seperate workbook in order to save file size for emailing but it looks like we cannot re-fresh it unless the workbook...

I have a large dataset (almost 300K rows) with multiple years of information (2003-2016). I'm trying to assign size into a Small, Medium, and Large category by year. My first attempt was to determine the quartiles then manually assign the size to a category but I'm sure there is a more efficient...

So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...

I run Win10 Pro on a Thinkpad. The size and position of opened, then closed Excel-windows is not preserved between Windows-sessions. This is true for other windows as well, e. g. Edge. They reopen at any position and/or any size. Is there a setting to keep positions and sizes like in former...

I'm attempting to create a macro that formats a worksheet of raw data. The macro is deleting unneeded columns, wrapping text, selecting page size and margins for printing etc. There are no formulas in this data. Once I record the macro and go back to test it, it formats the columns and page...

Is there any correlation between file size and eating up lots of battery life on a small portable PC? Some of our sales reps are experiencing battery life shortages and someone said it was the size of one the files they use, around 15M. I googled around a bit and found nothing to confirm this...

Hi All The font size in a drop down list changes to become unreadable when I choose to print preview. The result prints in the smaller size too. It is the same whatever pc or printer we use. There are posts about changing font size but, nothing I can see that describes this issue. Any...

The font in the formula bar somehow changed to italic and also one size smaller when I press F2 and the font is also showing in grey colour. But this only happen in one of the excel file. When I opened other excel file, the formula bar works perfectly fine and the font size & colour remain...

Hi! I am trying to return the size of a selection, when I specify the type and output required, which may not match the exact output, and therefore needs to find the closest match, for a certain type. <tbody> A B C D E F 1 Type Output Size Type Single 2 Single 200 300 Output 175 3...

Dear team, How to add picture into cell & resize automatically to cell size & should be hide & pop up when mouse over again hide when cursor removed from cell

Hello, I have a userform which Height"1080" , Width"1920" and with below code when its populated if I run the whole code, the background picture doesn't fit at the screen even though picture size is 1080*1920. The reason of that size is I'm going to use that userform at the big screen tv. Is...

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down...

I am new to Mr. Excel I look at it often for answers to questions about formulas that I have. Most of the time I can research it out enough to figure out and find a formula that works. I don't like to bother people if I can do it myself. But I just can't figure this out. please help. If I have...

Hi Any help would be greatly appreciated as I'm a novice at pivot tables. I have created a pivot table to summarise a large data set . I have calculated the average size within the pivot table and a column that shows the max size allowed within spec. What I would like to do is to have a...

In the below code, I'm getting a subscript error on the line in red. Any ideas why this would be? Private Sub OK_Click() Dim x As Long, ERow As Long Dim PINamesArray As Variant Dim size As Long Dim SearchRange As Range Dim FindRow As Long Dim k1 As Worksheet Dim k2 As Worksheet Set k1 =...

Hi all, I'm trying to think of a formula to lookup values from a list to decide a right size product for an order. For example - this is the range...

Hi everyone! My file size is upto 29MB, although no data is entered yet. How can I reduce its size as there is no excessive programming or pictures in it.

Is it possible to have a picture inserted that is roughly the size of an icon in a cell that opens up to a full sized image? I don't want it linked. If I drag and drop a file from an email, it links to the email. I want to be able to open the picture to see it in full size, but not take up...

The font size in one column of my data is different from the others. How can I keep the correct sizes when the data is concatenated? Thanks!

I have a large file that is about 2,000 kb in size. I am looking to add more rows in it with formulas and when I do the file slows up. The file does contain a few Macro's. I have tried saving the file as "Binary" and I even change the Calculation Options to "Manual". Even with a smaller file...