I created two excel templates and named them book.xltx and book.xltm and saved it to the following directory: C:\Documents and Settings\username\Application...

Is it possible to have multiple pivot tables on one worksheet? The various pivot tables will be using the same source data. I just want to show different...

Dear All, I was looking through some Macros in one of my sheet and may have inadvertantly changed something, now when I go to open any excel sheet I get the...

I create daily worksheets. Each row has a unique identifier (UID). These UIDs even drop off thru time and new ones are added. The data that I want to pull...

Hi yet again, In 2003 it's in Pivotchart dropdown on the toolbar. I miss toolbars ..... Best regards, Bony

There are 5 worksheets with links to internet site, whenever I open this worksheets, which will automatically update the links for all worksheets. After one...

I have a column titled Unit Price, I need to be able to find a way of firstly choosing whether it is n £, $ or Euros and calcluating the exchange rate...

New to Excel 2007 (not happy for what it's worth). I'm saving a file in a folder....I'm aware that there are other files in this folder (Excel and...

Is there any way to return to the pull down menus? I am so word oriented and those little icons (and words) being of various sizes and taking up different...

Can I sort by the second letter in a column? The first letter is the same but the second letters are different and I need the sort to the second...

I downloaded to my desktop, a sample of work from a coder. It was an array, 10 cells by 10 cells, with a number in each cell; there is a column of "1's",...

i have a question about & operator.i was using that operator in a vicious circle ( for x ...next x ). but that operator not runing with my vicious.. example...

In Column B I have listed various product codes, these codes are a mixture of both alpha and numerical characters, some are duplicated several times in the...

I have a list of favorites (restaurants). I want to sort by the most to least popular.

Hi I have data in Excel Sheet in the following way A B C 123 234 1 2 2 123 The data in Column B have to compare the value...

I have a link to Excel 2007 data in Access 2007 and when changes are made in Excel... Access is updated. I have tried to connect to Access data from Excel...

Hello all, I'm needing to do the following: if(and(a1=b2,c2=d2),e2,"") but, I need to look through colums. Like Vlookup. if(and(a1=b:b,c2=d:d),e:e,"") Thanks

I am designing an excel file for my school system. The goal is to allow teachers to input a class roster in a row, then have other sheets designed for...

I have two columns (B & C). Column B contains a list of names. Column C contains a SUMIF formula that checks Sheet '1st By Group'. The SUMIF formula, when...