General

ROLE OF XML IN EXCEL 2007?
I have just installed Excel 2007 on my computer. Have heard about XML playing a major role in the new version. 1. Any source of finding out the role of XML; & 2. What XML is all about? -- Best Regards, FARAZ A. QURESHI ... 4 Jul 2008 02:51

Subtotal and Grand Total Functions
Hello all. For the life of me, I can't get my sum functions to work with text entries. FTR, I am using Excel 2003. The purpose lays in this example... I have a column with three different alpha-codes that have been designated like this: A denotes blue textbooks B denotes brown textbooks C denotes red textbooks ... 4 Jul 2008 07:57

Help!..Why won't my CSV file open?
Everytime I try to a open a csv file in excel viewer, a message saying Microsoft Excel Viewer can't open files of this type appears. However, I have no problem other spread sheets in excel and I have no problem opening it in my office computer. I've downloaded office 2003, but still no luck! Any help would ... 4 Jul 2008 00:49

How to find dublicates in Excel and delete it?
Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. ... 4 Jul 2008 07:57

Formula Result = Volatile ??
Hello; 1) I've noticed recently that opening the same simple w/b and Enable Macros, ALL values on the active w/s would momentarily display correctly, and then (generally speaking) the cells containing formulas (e.g.; =SUM(A1:A10)) would display FALSE and those containing references would display False. (I'm n... 4 Jul 2008 21:16

excel add-on (QUICKSEARCH)
I have today purchased the QUICKSEARCH add-on for EXCEL from SHARE*IT which I now know operates via the following SUPPLIER... Digital River GmbH Vogelsanger Str. 78 50823 Cologne Germany ... 3 Jul 2008 23:48

Excel 2007 sharing issue
The file I have is not supposed to be a shared file. I expect when I have the file open, someone else trying to open it will receive the standard message saying it's already open, and do they want to open it as read only or be notified when it's free etc. Sometimes this happens. Sometimes, however, it happ... 3 Jul 2008 23:48

Anyone got an easy solution
I have a file that contains personal details, training details and costs & income. There has now been a change in the way we are to claim the income and provide reports. Unfortunately we are still required to maintain those on the old process as well as the new process. What I thought of doing was creating a n... 3 Jul 2008 21:45

Counting values in mulitple worksheets
I am trying to count values in a specific cell on multiple worksheets. (The cell is in the same location on all the worksheets). Something like this: Count all values = to "Y" in cell A24 on all worksheets. Anyone have any suggestions? ... 3 Jul 2008 23:48

Sumproduct absolute cell references
Hi, I need to make the following formula "completely" absolute in it's cell references. =SUMPRODUCT(('Analysis Working'!$Y$2:$Y$2100="A")*('Analysis Working'!$C$2:$C$2100="Accounting & Legal")) I am currently running a macro on the sheet it refers to that deletes lines. Each time I run it the formula sh... 4 Jul 2008 04:54