| Thread | Last Post | Replies |
|
| When I attempt to save a workbook I get a disk is full error | 24 Jul 2008 15:42 GMT | 6 |
I have a copy of Excel 2003 installed on a server. It is in a share were the 4 people on out team can access throuh a mapped drive. When any of us open the workbook make some changes and attempt to save it we get a messavebox that says the disk is full.
|
| find largest number | 24 Jul 2008 12:34 GMT | 11 |
i have a spreadsheet containing 2 grids of data relating to an op the grid range for grid1 is B6:bb56 grid 2 is B64:BB113 in a third grid i have this formula
|
| How to copy data from a "parent sheet" to another | 24 Jul 2008 06:53 GMT | 19 |
I have a massive master sheet that I need to break down into multiple sheets based on data. Here is what I have: 2: FIRST LAST BIRTHDAY PHONE ADDRESS CLASS Then 230 rows of info. What I would like to do is take all the class 1,
|
| Possible formula question | 24 Jul 2008 04:13 GMT | 6 |
I am working with a workbook and wanting to pull a number from one spreadsheet into another that will auto update as the pulled number is changed. Any help would be greatly appreciated. Thanks,
|
| Data into an Excel Form | 23 Jul 2008 19:26 GMT | 4 |
I created a form in Excel 2 fields are intended to capture Employee ID# and the other Employee Name (no need for separate fields for First & Last). I have a list of names & ID# also in Excel which I need to create 200+ individualized forms. I would like to generate the forms ...
|
| how to speed up VLOOKUP? | 23 Jul 2008 18:39 GMT | 8 |
I am currently working with large worksheets with lots of data and I need to use VLOOKUP (or similar) quite often. I know about complexity theory and thus I already make use of MATCH and INDEX to reduce the number of calculated lookups. My lookups work
|
| Unable to sum numbers taken from websites in excel | 23 Jul 2008 18:33 GMT | 5 |
I copied numbers from a website to excel. I sum-ed the numbers up, but excel seem to be unable to recognise them as numbers. e.g: 8,735,279 13,037,465 4,932,955 7,304,148 7,538,364 --> sum =0
|
| Pivot table caused 50 MB excel file | 23 Jul 2008 07:53 GMT | 5 |
I used more than 15 pivot tables in an excel file. It also have quite a lot of formulas. Though there is hardly much of data, file size has increased to 50 MB. In my quest to find out what caused this huge size, I deleted all the sheets
|
| Have a value be shown as the referneced cell | 23 Jul 2008 02:33 GMT | 17 |
I am running a formula =Max($a$1:$B$55,1) to find the largest number in a set of data. The answer was found in cell A36. The formula was fine but I was wondering if there is a formula that will display the answer's cell location.
|