General

re. Mapping Software
We are the vendors of the Maptitude <a href="http://www.caliper.com/">Mapping software</a> product that should meet your needs and I would be happy to demo the product to you. See: www.maptitude.co.uk Rich wrote: Mapping Software 31-Jan-10 Hi, I need to use a map of the UK and show UK branches red, amber... 3 Mar 2010 15:17

Excel 2007 highlights multiple cells when trying to select one.
At the bottom of your Excel Sheet you may find a menu bar that starts to your left with the word "Ready." Look to the far right on the same bar and you will see three small icons (1 = normal; 2 = page layout; 3 = page break view). To correct the problem, make sure that you are on "normal." Your problem will go ... 3 Mar 2010 15:17

Templates in Excel 2007
MY TEMPLATES do not show up in "new" on Excel 2007. I changed the setting in Trust Center Settings to redirect the path of my User Templates, and I checked the box for "Allow Trusted Location on my network". When I attempt to open a template in My Templates, I get the following "To add a template to My Templa... 3 Mar 2010 13:02

excel Visual basic opens then closes for users
I have users with Excel 97 on a domain. One of them is learning VB in excel. When she opens the visual basic editor it imedietely opens and then closes. When I do it as administrator it opens and stays open. Obviously a permission issue. Does anyone know how to allow her to open the VB editor in Excel and use ... 3 Mar 2010 13:02

Sorting Question
Hello all. I have a list I am working with. The columns I am interested in are Employee, Overtime Code, Pay and Comp. There are approximately 50 overtime codes. I need to strip out some of those numbers, and then total the pay and comp columns for each employee. Like so: Jones 1 4 0 ... 3 Mar 2010 13:02

Combining Percent with Text
Hello, I am attempting to show the percentage complete (in a cell) using the COUNTIF function. I first formatted a cell (example A1) as a percent the I enter the following formula in cell A1: =countif(b1:b12,"Completed")/countif(b1:b12,"*") It returns the correct value in cell A1, however, I would like to ... 3 Mar 2010 15:17

How do I set a pivot table to group quarterly reports by F/Y?
I'm trying to set up a report in Excell using the pivot table function. When I use the "Group Field" function to generate a quarterly report it assigns each quarter according to a calendar year which puts the Jan 2010 data in the 1st QTR and the Oct 2009 data in the 4th Quarter. I want to change this so it be... 3 Mar 2010 18:41

In Excel 2007, the open file window does not display the folders p
When I'm in excel 2007 and I want to open a new file, the folders pane is gone. I used to have it and I even added folders that I used most frequently but now it's gone. I know the IT deparment did an upgrade but others still have it and I'm the only one that got affected. Please help, now I have to navigate ... 3 Mar 2010 11:51

Need to clear cell values, when a different cell is changed.
I have a value in C3, and when this values changes, I need to clear out cells D3:E22. Excel 2007. Thanks in advance ... 3 Mar 2010 18:41

Auto-start macro
Hello, I have a simple macro in Excel named Macro1. How can I make Macro1 run automatically everytime I start Excel? Simple step-by-step replies please. Thanks in advance. ... 6 Mar 2010 14:05