I have received some forms that are MS Excel 2007 and I have 2003. How can I open these? If I am unable to open these can the sender save tham differently...

Somehow my default currency character has changed to "TT$" instead $ English (United States) so I have to manually change it all the time. How do I change it...

Hi, I am trying to return an integer for the number of characters from the left of a string that the character "/" is located. I need to do this using VBA...

Where has the freeze pane option been placed. When I am editing an existing spreadsheet, I am unable to view the column titles on each page.

I have a column with numbers running from 1- 100, I used custom autofilter to find all numbers beginning with 1 but it returned only all the empty rows, why...

Hello: I have a macro in a workbook that I've created on the first worksheet. I have 11 worksheets in the workbook and the same macro needs to run on each...

If you can't complete a training practice in one sitting, can you save the workbook to continue on the next day? How do you do that? -- anc

How do I do a find and replace the 2 numbers at the end of the field in a column?

I want to compare two different optimal scenarios answers obtained from Solver but they are quite close. I want to say, well scenario X's optimal value is so...

I am doing a mail merge from Excel 2003 to Word 2003. The Excel file has 3 worksheets, and it a protected file. When I browse to locate the file to use for...

Hi, I am using the macro attached below to drive a series of worksheets, graphs etc. I would like to change the protect and unrpotect sheet parts to...

I have an Excel 2007 file in which I use 6 different conditional formatting rules. This spreadsheet is also uploaded to a wiki page. I use an Excel plugin to...

I updated the source files to add and remove some rows. The .xlt file that is used to display the data show the old data. I do I refresh the .xlt file? --...

I've found that if I modify the folder options for .xlsx file types by adding "%1" to the end of the Application used to perform action: string, I can open ...

Hi there I have a file that has several worksheets that I have created a worksheet that compiles the information from the various worksheets using links. ...

I have cut & paste numbers from a web page & this has brought an imbedded link onto my worksheet. I cannot select it to delete it & it sits on top of the...

I am trying to allow managers data entry into one column. The column next to this column is a formula that is cell protected, but needs to calculate based...

I am new to 2003 Excel. Is there a function same as 2000 Excel's Protection of 'Objects'. I have tried the protection function in 2003 Excel and untick...

Hi, i need an macro that fill an cell with some numbers and when i select that cell, i can add something to that text: ex: database sheet! A ...

I am trying to move and reformat a footer in Excel 2007, but am having no luck. Any suggestions? Thanks!