i don't seem to be able to open an excel 2007 spreadsheet from my desktop by double clicking on it. If i go to the office button and 'open' it's fine. but...

In previous versions of Excel it was possible to close all workbooks with one command. Does anyone know if that's possible in Excel 2007?

When I try to save a workspace in Excel 2007, I get the error messsge: "The extension can not be used with the selected file type. Change the file extension...

HiGuys I need to be able to report the age of someone at a given point in the future. I know how to use the year(today) formula which works great for age at...

A1 and B1, A2 and B2, A3 and B3, etc. contain item codes that are matched. this spreadsheet contains about 200 matches like this. i have another spreadsheet...

I have a file which is apparently locked as in use even though it isn't. All users of our network have restarted their computers and the file is still...

I have put together financial statements in a work book. Now, i would like to enter a logical / if then, segment to my equations but i dont want to go into...

Please, need help. I'd like to create a dialog box that will ask for Name, address, etc... and the information encoded will be placed to a worksheet. --...

Hi. Can anyone help? How can I permanently link column A (a list of names) in multiple sheets, so that if I edit (ie to insert a name) this is reflected in...

In a spreadsheet containing 300 rows of data, I need to automatically insert a blank row after every row of data. PLEASE can somebody help - it's sooo slow...

I have a spreadsheet with 12 months and under each month are 6 columns of information. I am trying to come up with a way that on a blank worksheet, you can...

I've been given an Excel spreadsheet with 122 record UPDATEs. I have tried a CONCATENATE Statement, see below. My one problem is getting the "/" into my...

We have the compatibility pack and when i create a pivot table in 2007 and save backwards it only works if there are less than 40000 lines of data. I know...

I am having difficulty writing a formula and hope that someone can help me. I've written out the formula below and need to put it in the correct Excel...

i forgot to save a file, can I retrive it somehow

This has annoyed me for some time. (Excel 2003 and probably all others) Excel changes the aspect ratio of items when it prints and I dont know why, but I now...

In Excel 2003, I used the web preview and save web page features to save two databases as web pages. They won't display in Internet Explorer. They do appear...

Dear All, It will be easy if there is any Key Board short Cut to go to a Specific Work Sheet in a Work Book. For example i am working in a work book which...

I wish to sum the values in a column that meets certain critieria such as greated than 35%. I can write the formula so it works but I have been unable to...

I have 2 Pivot Tables in a worksheet. They both have Date, Total amount. One Pivot table is producing deposit info from the ERP data while the other one is...