Hello wizards! There's a way to show only the last column (grand total) in a pivot table? I have to present the worksheet but the audience does not have to...

I need a code either a formula or better still a sub procedure or function for storing a current date value which cannot alter after that date and the...

Is there anyway to change some of the fields in excel as a regular file (xls) then change it back to comma delimited? One of my clients wants his fields to be...

I have been searching for an easy answer to how to align 2 sets of data each with several corresponding columns. Both sets are sorted by company name, and I...

Running MS Excel 2003. Is there anyway to resize a cell, or group of cells, without resizing the entire column/row? For example if I have 3 charts, one on top...

I need assistance. Everyone workbook I open in Excel 2000 keeps giving me the message "A document with the '___.xls' is already open. You cannot have two...

I am fairly new to Excel and need a good reference (the help section isnt good enough) that I can grow with. Is there a definitive guide accepted by most as...

I have a protected sheet, in that some cell are protected, it is used by others also. What i wanted to know is, if somebody click one of these protected cells,...

I need to use a variable in a cell reference to another workbook/worksheet. I have an example shown below that will NOT work. What do I need to do to fix it? I...

hello, I am taking a class and my books have yet to arrive. One of my assignments for the week is; What are the advantages of dividing a worksheet into...

Hi, I am developing a Excel based solution and that requires circular reference in the formulas. However I am ok with setting the limit that each cell be...

Dear all, I work on a mac and Visio doesnt work and am not willing to pay for a mac version (if there one). It must be possible with all your brains out there...

What does it mean when a spreadsheet title finishes with ? Why is it not possible to sort the information as A-Z ? -- Billy

I recently got a new computer with XP Pro on it. I transferred over my files from the old Win 2000 computer and got things running fine for the most part. ...

How can i select all sheets of a workbook? Is it possible to select all work sheets of a work book? Thanks --- Message posted from...

I have an Excel speadsheet of data that I would like to print out a seperate form of each record (line item). I am familar with Access's ability, though I...

If you are a Visual Basic programmer and your mouse wheel won't scroll in the VB Editor, then go to the Microsoft Knowledge Base and get article 837910 with...

I need to make a spreadsheet for a cinema How can i make it so that each time a seat is sold the cell that corresponds to that seat changes...

My Excel Viewer doesn't function anymore, I cannot get it to load. When I start it up, it says that it cannot find the XLINTL32.DLL. I have checked on my PC,...

Hi, Simply: I have a cell containing another cell address. In another formula I wish to refer to the address in this cell. How do I do this? In more...