General

Filtered data range reference is too complex
Twist on the same error message. I have a spreadsheet using approximately 630k cells. It has been the same relative size for several months. This week after I apply one or two filters I get this error when simply trying to use find/replace. "Shane Devenshire" wrote: Hi, When you filter data th... 17 Mar 2010 13:39

2007, excel column hdings are now numbered - how do I get letters
I just started using microsoft 2007, and in excel I noticed that the column headers are now numbers. In 2003 they were letters - much more user freindly. Is there a way to switch back? ... 17 Mar 2010 13:39

Excel 97 keeps changing dimensions of autoshape rectangle
If i create an autoshape rectangle in a worksheet and when I try and set its dimensions to 1.0 cm by 1.0 cm square, the app. changes this to 1.01cm by 1.01cm. Excel adds 0.01cm to every set of square dimensions I try and set. However, I do not see this issue up to 1.0 cm i.e. if I set the dimensions of the aut... 17 Mar 2010 13:39

Inserting Picture Into Protected Worksheet
Is this possible? At work, we use Excel 2003. I have about ½ dozen cells, with formulas locked, but the rest of the worksheet is unlocked. When I go to Protect the sheet, I can no longer insert a picture. Can I do both, protect a formula from being deleted or altered but still be able to insert a pic into a... 17 Mar 2010 15:58

when I type a long number it shows up as smaller number and +
when converting from xls to csv format, some of my longer mortgage numbers get condensed into a smaller number with a letter, a plus sign and another number. example: 100020013120 turns into 1.0002E+11. Any way to get rid of this? Thanks, ... 17 Mar 2010 15:58

how to combine several files, all with same columns, into one shee
In the process of helping clients manage their spreadsheets I have developed a web application that loads, organizes and reports upon a portfolio of spreadsheets. This application is not yet being offered as a "product" or "service" but I invite you to check it out at http://www.spreadsheetmanagement.com/ I may... 17 Mar 2010 12:31

Filling right header/footer with barcode
I have an access 2000 app that generates an Excel report for my customer. everything works fine except the code i'm using to write the file name into the right header. the file name must be in both normal font and 3 of 9 Barcode. the file name in normal font is good but the barcode does not scan. i have pos... 17 Mar 2010 12:31

Need help with organizing my excell data base
In the process of helping clients manage their spreadsheets I have developed a web application that loads, organizes and reports upon a portfolio of spreadsheets. This application is not yet being offered as a "product" or "service" but I invite you to check it out at http://www.spreadsheetmanagement.com/ I may... 17 Mar 2010 12:31

A formula in this worksheet contains one or more invalid reference
I continue to have this error come up when ever Excel recalcs and I can't figure out where it is coming from. What kind of errors would be causing this and where should I start looking. My spreadsheet is retrieving pricing data from an Access table based on a query that only imports the data for a chosen st... 17 Mar 2010 14:47

Formulas
I want to enter the formula =IF(Data!D18="","",Data!D18). Is there any way to have the fomula automaticaly capture the reference Data in the next cells without manually typing it in as the Data is not consecutive. Example below =Data!A18 =Data!B18 =Data!C18 =Data!D18 =Data!A20 =Data!B20 =Data!C20 =Data!D20 =Da... 17 Mar 2010 11:23