General

after saving excel 2003 file, functions do not update anymore
When I open Excel and make a SUM of several cells, the SUM is displayed and calculated correctly. If I save the file and re-open it and change any value of one of the cells in the SULM, the result stays the same, the SUM is not recalculated. If I create a new SUM in this Excel file, the result returns ZERO. Cal... 7 Jul 2008 09:24

Expanding a data table to include an extra row
I need to expand a data table (or 'special array' as referred to in this discussion group) to include an additional row. Previously I have been shown how to do this and it worked then, but have forgotten how too!! Across the top of the array are dates (cells D16 - J16) and on the far left of the array is formu... 7 Jul 2008 05:19

Superscripts in a cell
I have Office 2003/Excel 2003. I have had no success in putting a superscript digit in a cell to reference a footnote. Is it possible? The superscript takes until I tab to another cell, then it turns into a regular number. Thanks for any help you can give me. ... 10 Jul 2008 13:25

Time and Date Formula
I would like help on a bit of a problem i have for time keeping. I have a sheet where i can keep track of my equipment, when ever an employee checks out the equipmnet, it give me the time and date when they did...but every time a new employee check out anoter set...all the cells automatically update....Is the... 7 Jul 2008 04:18

Auto colour when other conditions already in place
Hi I have a sheet where multiple conditions are already applied using CFPlus (my new best friend!!) but now I want to have a selection of cells on that sheet (some already conditioned some not) turn a specific colour as soon as any particular cell in a stated range >=16 - would I do this just by adding yet a... 7 Jul 2008 03:17

Can not print in Color
My problem is : multi sheet documents, only the first sheet print in colour the rest of the sheets are in grayscale. Excel 2003 sp2. "Nick" wrote: I have the same problem. We are using Offcie 2003 and right after upgrading to SP3, Excel will not priview or print in color. "Print to PDF" works in colo... 7 Jul 2008 01:15

All about numbers
I have the following table: A B C D 3 1 0.5 0 2 2 0 0.5 3 2 0 0 0 1 0.5 0 1 0 0 0 2 1 0 1 1 2 0.5 0 4 1 0 1.5 The formula required is to: 1) check if any row in column C has 0 (zero) and see corresponding cell in column D also has 0 (zero). Table above shows row 3 and 5. 2) if matches, then check if (... 7 Jul 2008 01:15

Conditional Format - Identifying Highlighted Cells
A brief explanation: I have 3 columns of data: X, Y, and Z. User inputs a high/low ranger (i.e. 4 +3/-2, i.e. 2 to 7). If the number is outside of that range, I have used conditional format to set the cell color to gray. Now here's where I have a problem. I'm attempting to add a fourth column, OK/NG column. I... 8 Jul 2008 21:20

Formula error - Excel 2007
Hi , I have used Excel for many years, but, for some reason, I am having a problem with what I thought was a simple formula. I am trying to work out a depreciation figure, and the net written down value. B35 Puchased 14/05/2008 B36 Private Use 50% B37 Cost $899 B38 Days owned: 47/365 B39 Depreciation Rate 3... 6 Jul 2008 21:10

Does anyone have a template for printing L7160 address labels?
Hi Mackydees I've just seen your post; are the labels (L7160) an Avery product? the reason I ask is that you can download, for free, blank templates for all their products. If you go to http://www.avery.com/us/Main?action=software.BlankTPLHierarchy&catalogcode=WEB01&node=0 you might be able to find the temp... 7 Jul 2008 02:16