fix

Hi All, I have created a set of bubble charts. The 'Z' value has positive and some negative values. When positive, the bubbles look fine. But when negative, the bubble disappears and no negative values are shown. How do I fix this? Thank you in advance.

Hello I use this formula TEXT(A1,"00%") to display some numbers like 0.09398345 into 9%. However, it shows 09% instead of 9%. How can I fix this please? Thanks!

Dear all, I would like to fix the operation range from A1 to K20, prevent operator to disturb other range setting & data, please help to teach how to fix it & back to normal status. Thanks for help. Cannny

Hi All, Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread. This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved. What i'm trying to do is calculate and populate the SLA Deadline cell...

Hi Guys, can anyone tell me what's wrong with the following construction, please? All three components work individually so I assume it's the way I have put them together that's the problem. In the below, only the first component works...

Hi to all, I’m tried to make a formula to get the last value acomulative in cels from B thru E. This is the formula and the result that I obtain is 0. =if(E2<>””,E2,if(D2<>””,D2,if(C2<>””,C2,B2))) The last value is in Cel D and it’s supposed to be 3. Value in Cel B is 1, Cel C is 2 and Cel D...

Not sure what but in a cell I type =c59 and all I see is =c59 ...I want that "code" interpreted not taken literally ...how do I fix this has some property been set on the cell?

When I freeze panes it doubles up some descriptions and missing others, scrambling the headings. Does anyone know how to fix this? https://docs.google.com/a/roche.com/document/d/e/2PACX-1vRsyVHnJnnYX4WvW0GJAkQrU40TkIj93y4tr5Or-5SYkTBVw6YA8BV4qDRrnS3WRiM80DOXL5ISbayA/pub

Hello, We created a macro to send out personalized emails to our customers with each individual email having an attachment of that certain customers invoice. When running the macro I seem to keep getting stuck where it says : MyAttachments.Add(attachment). Not sure if there is some way to...

Here is the problem I need help with, K60 changes constantly and 0nce K60 gets below 190 it starts giving negative Numbers. How can I fix this formula not to do that, Thanks 4 Barrel Harold [CODE][/=IF(NOT(OR(K60>(K56+K48))),IF(K59>K60,K60-K56)*N13,K48*N13)CODE] Here are the number that I'm...

Hi there Usually when I am running these reports and I have a lot of text in a cell and I have expanded the cell to as wide and large as it can be, usually I'd only have a handful of rows with this issue in a field, my usual quick fix is to insert a row below where the large is cell is, merge...

Hi guys, I have a workbook that uses large sets of data ~8000rows and counting, and whenever I close this work book, Excel gives me the "Out of Memory" pop-up, once I click okay it pops up again, and again... The only way to fix it is to close all my workbooks. > I have Formulas that use...

Hi, Excel isn't working. It isn't calculating basic calculations. When I type in the formula in cell A1 = "C23" it does not show the result for cell C23, it just shows the formula itself. "=C23" How do I fix this? Thanks

Hi I entered time like this 1:30:44 am but excel only shows 1:30 am. Why is that and how can I fix that? thank you so much.

I want to add all data from D3 down to last used cell then go down 1 and place that result there. Can someone fix that for me?

https://drive.google.com/open?id=1-kA3-Z4sFfSET2uHxkHnjFu9wiJRvVB_ Please find the attachment above there are 3 columns, serial number,co-ordinates(x,y) coming to serial numbers it is not in proper arranged serial number EX:(1,2,3,11,14,15,18,....214..) i want to arrange serial number...

My excel workbook is password protected. And file has macros but my macros are disable when the workbook is password protected. Please helm me to fix the problem. And show me the setting. Thank you.

Hello, I have a function but when I click the + icon it does not populate across the whole column. Any idea how to fix this please? Thanks

Hi I fixed $J$1 in the formula and accidentally moved J1 (dragged and drop it somewhere else), the formula below will update $J$1 to the new location for example $L$20. I thought $ will fix the address? I know I am not moving the formula but still? Thank you so much. <tbody> I J name date...

Hi, I have two pivots: Pivot 1: Contains the Month, Zone name, Store type, and Store ID (All in the pivot field) Pivot 2: Contains the Month, Store type and product wise sales I have then created a slicer on "Month" field for one pivot and connected it to the other pivot. However, the slicer...