Recent content by excel_stuff

Thank you, Hui. This is very helpful. From your list, a potential cause may be: "Had anybody opened the file in a newer version and then saved it in an older version, Excel may have reset the used ranges in that case" Its interesting if Excel can potentially halve the size even if the file is...

Thanks Hui. That's very helpful. However, the first halving happened when both files were saved as 97-2003 version. Isn't that odd? Thanks

Hi listers I have had this problem twice that Excel files reduced to almost half the size. First time from 14MB to almost 8MB (both files in Excel 97-2003). The second time from 8MB to 2.6 MB (this time file saved as Microsoft Excel Macro-Enabled Worksheet instead of Excel 97-2003). The...

thank you. I'll give this one a go.

Hi listers, This is probably a simple question for many of you. I am working with someone else's workbook and have renamed cells and some names are redundant. So I want to find (and maybe list) all cells that are not used in any formula in the workbook and then delete them. Is there an easy and...

Thank you both. This is very helpful and will save me a lot of time. Many thanks!

Hi Excel gurus, I have a quick question and would appreciate advice. I have a lot of named cells which I use in different formulae. Every time I want to go to the actual location of the named cell I go the Name Manager and find the named cell and then close it and then go to the location. This...

Thanks. Yes, they are using Excel 2007. Now I want to make my file universally accessible. How do I overcome this problem? Thanks

Hi listers, I am working with Excel 2010. I have used conditional formatting rules using simple formulae and a specific RGB color format (to define red, green and amber colours). However, when I sent the file to my colleague, it was all in one colour. Can anyone suggest a solution to this...

Excellent. This works perfectly! Thank you again!

Excel 2010. Thanks.

Sorry just a follow-up. I can easily add vertical error bars from the chart layout menu but cannot find horizontal error bars. Any suggestions? Thanks.

Excellent! Exactly what I wanted. I was making the mistake of using a negative number which didn't work. You are a Ninja!!

Thanks, Hui. Sorry for the late reply. This is very helpful. Attached is what I was looking for. Now I need advice on drawing confidence interval for the point estimate (see attached). I would really appreciate your help.

Hi colleagues, I am struggling with perhaps a simple dashboard question. I am trying to replicate bar charts in KPI dashboard - revisited II (available on chandoo.org). My minimum value and first quartile are below zero while median, third quartile and max are positive. I also have a target KPI...