General

TABLE ROW SORT ERROR?
Hi all - I have a 22+ column by 867 row table. Three columns host formulas on each row that refer to values on the same row. Everything is fine until I sort and/or filter. Then, the formulas point to other rows, even though the right values appear on each row. All rows and columns are included in the table. ... 6 May 2010 15:24

Excel 2007 Crashes when Saving to .xls
Has anyone solve this problem yet? I need help with the exact same problem. thanks. Diana wrote: Excel 2007 Crashes when Saving to .xls 31-Aug-09 I have a workbook with a large amount of VBA that works just fine in Excel 2003. However, when I open the file in Excel 2007 and try to "Save" or "Save as" i... 5 May 2010 16:03

Can't lock cells
I have a spreadsheet in which I have locked certain cells, then I protected the spreadsheet (Tools >> Protection >> Protect Worksheet). However, I can still write to the locked cells. I can prevent that by not allowing users to select locked cells, but I would like them to be able to copy and paste. What am I mis... 6 May 2010 18:45

Online Help
Does anyone have any experience of creating documentation accessible through the Excel Help menu item? I have successfully created a series of Excel 2002 templates and wish to create a user guide for them. My work environment prohibits downloads or specialised software, so RoboHelp, etc is not an option. My... 5 May 2010 20:31

Auto sorting to match
Hello All, I have a spreadsheet that automatically sorts catagories by largest loss or lowest # in another column. My original data is not sorted in the same way, so when I compare the two, they are miss matched, this is improtant because I can't change the order of the column that is now arrainged from larges... 6 May 2010 16:32

Help with Google Groups search
Forgive me for this off-topic request. But since it impairs my ability to help people with Excel questions, it might not be entirely inappropriate. I have not gotten constructive help through the Google Groups forums in the past for similar problems. If you can find the following article using Google Groups ... 5 May 2010 13:48

subdividing a column
I am trying to develop a spreadsheet that I can list 2 columns of information under each month column...Is this possible in Excel? ... 5 May 2010 13:48

Excel and SQL Server
I need to populate a column in Excel from SQL Server based on data in an existing Excel column. For example if I have a spreadsheet with employee ID's in a column I need to go to SQL Server and populate the employee names associated with the Employee ID's into an adjoining column. I have found plenty of articl... 5 May 2010 14:55

simple loop needed please
basically i want the macro to enter values 1 to 5 for range g2:g6 then move onto row h2:h6 and start with 2 and place i and the bottom so it should look like this Column G Column h Column i 1 2 3 2 3 4 3 ... 5 May 2010 13:48

Plotting
I have an excell spreadsheet that is used as an schedule. it was built using office 2003 and I could send it to the plotter using some modified changes. We were forced to change to office 2007 and I can only print 1/5 of the ducument. This document is approx. 3'x7' when printed. Is there a compability issue or ... 5 May 2010 13:48