Search results

This article is perfectly right anyway : 1. XL is familiar, and easy to set up something. but ... At this point, the headaches usually start rolling in due to version control. is something coming regularly and I have difficulties to fight out. XL cannot do multiuser / concurrency...

Custom number formats are better and a faster way to achieve this, since if you achieve to have a high number of row, Excel will spent all its time calculating the helper column ... Note that they can print too :)

Thanks a lots for this link, but If I can avoid them (macros and forms) I do... since my users won't activate macros if they saw a popup ( kinda paranoids ) !

Hello Hui, Here's my screenshots (in French, I can't translate screenshots in English :-) Starting point : Planned / Days http://dl.dropbox.com/u/4900864/Gantt000.jpg Switch to Weeks ==> Wrong format (as shown in img 002) http://dl.dropbox.com/u/4900864/Gantt001.jpg...

Hello Hui, Here's my scrennshots (in French, I can't translate screenshots in English :-) Starting point : Planned / Days http://dl.dropbox.com/u/4900864/Gantt000.jpg Switch to Weeks ==> Wrong format (as shown in img 002) http://dl.dropbox.com/u/4900864/Gantt001.jpg...

Hello Hui, I've based the formating against the value of the cell (< 30000 or > 30000) but now I've changed to your way (which seems better with less calculations). Format 1 is "dd/mm", format 2 is "Standard." Now the behaviour is a bit different : When I select "day" I have the...

Yes, I've put two conditions, and checked the stop if valid checkbox. I've forgot to mention this worked fine in 2003 (Fernando's dashboard), but not in 2007.

Hello all, I want to conditional format a range of cell in "Short Date" or "Standard" if the condition is "Day" or "Week". When I select "Day" the format is OK, but when I switch to Week the format stays in "Short Date". I need to press F2 then enter to see the number format. Any clue ...

Thanks Chandoo, By the way, are the result of the Office2010 contest known ? Cyril

Hello, I want to achieve what Chandoo did in the following post http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/ The status dropdown is filled with symbol. I've made a validation list refering to cells A1:A6, formatted with "wingdings" font, but all I see is the "normal...

I've found what I was looking for. When you deselect some values in a row, you can add automatically new values with the following method: 1. Right click in the header of the field (either in the table or in the right-hand list in 2007 2. Go to Field Parameter : in 2007 you have a check...

Hello, I'm using a pivot table with a filtered row list (suppressed empty labels). My question is how do I automatically add new label to my table when the originating data changes. Thanks for your help. Cyirl

Hi Hui, I'm particularly found of "Open the second file hidden" comment from Jon Peltier. Put this in the Workbook_Open function.

It depends if TOTAL is automaticcally calculated by EXCEL (groups ans subtotal) or not. Best way is perhaps to use a VLOOKUP to retrieve total when calculating %. Look at the following table # payments # loans % Zero 14 =B2/VLOOKUP("TOTAL";$A$2:$B$6;2;FALSE) One 3...

Hello LabyBlack, Unfortunately, the external sheet must be opened for you to see the value in the Monthly Report. Another way to do so, is to "import" from an external Data Source. This way, use the Microsoft SQL Query with an XLS File and import the Forecast sheet in a new sheet of your...

Roy, I think about adding a % columns base on the total line. then Use this Column instead of the nb one. HTH Cyril.

Oops, it seems I've made a mistake. The real behaviour is that the line below the insertion maintains its dependencies : A B C 1 AAA 1 1 2 AAA =B2 - C1 3 =B3 - C2 ==> Correct, but the next line isn't changed. 4 BBB 3 =B4 -...

Hui, it is a 2007 Table (Insert Table). I've not repoduced the header in the post, but you're right there are here. I've selected the row, and right click > Insert line. Regards.

Thanks Hui for your answer. Unfortunately, I've double checked and I removed all formulas in the table. So I have a column without any formalas in it. When I extend the table, the formula reappears. Like if the table had kept it in memory (kind of homeopathic dilution :-) ) The only...

Hello, I'm found of the ability to automatically change a formula in a table and the way all cells below reflet the change. This is great. Unfortunately, I have removed a formula in a column, which was reported correctly below, but now, everytime I add line by moving the tick the formula...

Hello, I'm using excel tables with formulaes in some column. The table looks like this (formula shown): A B C 1 AAA 1 =A1 & "-" & B1 2 AAA =A2 & "-" & B2 3 BBB 3 =A3 & "-" & B3 The table is defined with the range A1:C3. When I insert a line...

Another related question : What if I need sum count against 2 columns ? Col1 Col2 ID A B AB001 A C AC001 A B AB002 ... Is there any cross-product function doing the job ? Thanks in advance Cyril Z.

For all interested, there is a side effect of "cutting" in the cell values returned from a validation list. You cannot define the width of the drop-down list, which is really annoying with long names. Is there any way to define this width and also the number of item displayed ? Cyril Z.

>oldChippy : VLOOKUP doesn't work with Excel's validation lists.

>Hui : That's exactly what I wanted to do. Thanks a lot