| Thread | Last Post | Replies |
|
| Excel 2007 | 01 Nov 2008 00:32 GMT | 1 |
dlaczego zamiast przecinka dziesiętnego wstawia prostokąt
|
| Accessing Data in an Open Excel Spreadsheet | 01 Nov 2008 00:16 GMT | 2 |
I have an Excel spreadsheet which is refreshed on a minute by minute basis. To ensure that the data is up to date the spreadsheet must remain open at all times. I need to access the spreadsheet and extract the data and load it into a database (could be Access, SQL Server 2000 or ...
|
| CSV VERS DBF | 01 Nov 2008 00:01 GMT | 1 |
Bonjour Il y a t il un moyen d'exporter du csv ou txt vers du dbf Excel 2007 n'exporte plus en db merci
|
| Extending Field Size in Pivot Tables | 31 Oct 2008 23:30 GMT | 2 |
I have been conducting interviews and some of the responses are long. I have tried to put them in a pivot table but there seems to be a field size limit. (By the Way, MS Access is not available). Is there a way I can either extend the field size which would be my preference or can ...
|
| to find out number off offdays of each employee | 31 Oct 2008 22:09 GMT | 1 |
I have to find the number of offdays depending upon the values of two cell A1 cell and B1 cell A1 ( Saturday) cell contain 1,2,3,4
|
| Changing data in a combobox when updating another | 31 Oct 2008 21:54 GMT | 1 |
I have a big problem to solve: I have several combobox in my form like this: cbocompany cbodivision
|
| Opened by another office documents | 31 Oct 2008 19:34 GMT | 2 |
For Office application how do I tell if the application was opened by right click->open from another office document. For eg. Excel opened from word via a right click ->Open on embedded excel doc in word or powerpoint. Is there an api that differentiate how the excel is opned.
|
| Saving a formula | 31 Oct 2008 17:46 GMT | 1 |
I have 6 spreadsheets and have been trying to save a formula in the same cell in all 6 spreadsheets but when I save and close out, its not there the next time I use it, any ideas on why?
|
| Calculate Accrued Leave Time | 31 Oct 2008 16:55 GMT | 2 |
I need to be able to track accrued leave time, but have no idea how to set up the formula. Here are the particulars: Accrual rate = 4.62 hrs. of leave per month, # of months = 12 I occasionally use a few hours in a month.
|
| Add/Delete/Change Comments in a Range | 31 Oct 2008 15:37 GMT | 1 |
I have a report to do, with the following fields: A B C 1 Group Channel Sales 2 He Hypermarket 300
|
| Option button | 31 Oct 2008 15:36 GMT | 4 |
I have a spreadsheet with one cell I want to deplay the price from one of two spots. How do I setup an option button so that if one is selected the price next to that button get put in my deplay cell?
|
| Lost in the 2007 ribbon | 31 Oct 2008 13:31 GMT | 2 |
I've lost the will to live, this 2007 version with its new ribbon has me stumped. I've had to create so many Quick access toolbar icons, it seems pretty pointless.
|
| Budget and sliding bars. | 31 Oct 2008 12:09 GMT | 1 |
Need some basic help here, this example will explain; I have a exactly 1000 to spend on a computer. I want to have some kind of bars that I can move with the mouse and if I raise the cost of the processor, the other bars should fall so that the
|
| Conditional Formating on three digit numeric cell database | 31 Oct 2008 12:03 GMT | 4 |
Have created a three digit (including zeros) numerical database in the range A2-A35 expanding now up to CC2-CC35. Note that leading zeros are not shown. My wish is to find the cells of same numerics in any random or repetitive (ex:567,576,657,675,756,765) in the whole database ...
|
| To find out number of sundays and saturdays in january month | 31 Oct 2008 11:11 GMT | 3 |
Hai all, How I can find out the number of saturdays and sundays in January For example in A1 and B1 cell represents Saturdays and Sundays. How I can find out the number of saturdays and sundays in that month and to write in
|