General

Pivot
Why does the format of my pivot chart change, e.g., colors, order, etc. when I "refresh" my pivot data. I have been hitting "save" on the pivot "chart" after I format it ,but it reverts back to default when I refresh the table. ... 22 May 2010 12:46

How do I maintain format in programs.
I am a teacher and I use Excel to quickly, easily create wordsearch puzzles for class and church. When I copy the cells to a graphic program it throws off the rows and columns. It is as if my words and the cell borders(gridline) are off set. I used help to inquire about aspect ratio, to no avail.... ... 22 May 2010 12:46

Add comma after last " in a cell
Ultimately, I want to do a text to columns method but 1st I need to make the data work properly. I have close to 9000 items of vary degrees of numbers and text. I want a formula that will insert a comma after the last " or ' in a cell, reading from left. 3/4" x 1/2" pvc pipe 1/2" x 1/2" x 6' black pipe 1' ... 24 May 2010 10:08

Hyperlinks for .rm files stopped working
I have many hyperlinks to open files from an Excel workbook. All of these work except for .rm, which has suddenly stopped working. These files open ok from the folder. What can I do to fix this please ? -- RichardP ... 22 May 2010 05:10

Keep formatting PC to PC
I did the page formating from One PC. but when i open that document from another PC, there's formating have changed. so i wanna know, how to keep page formating, without changing the page sizes with the contents PC to PC? ... 1 Jun 2010 13:06

Changing relative cell reference
I want to copy data from one work sheet (A) to another (B); instead of using a normal relative cell reference (i.e., copy A1 to A1, A2 to A2, etc), I want each row in worksheet A to be copied to every 31st row in worksheet A: A2 in worksheet A should be copied to A2 in worksheet B A3 in worksheet A should be co... 22 May 2010 07:17

using Excel 2007 student with Excel 2007 commercial
At home I have Excel 2007 student version. My boss has Excel 2007 commercial version. Can I work at home and transfer files to my boss's computer? My boss's computer would not open my work. Any ideas and help is appreciated. Thanks! ... 22 May 2010 16:03

I can't format cells
If I right click a cell, or a group of selected cells, and click 'Format Cells', nothing happens. The border button doesn't work either. This only happens in certain parts of one spreadsheet. What do you think it could be, and how can I correct it? ... 21 May 2010 23:49

Recording and playing Macro (Solver)
I've exactly the same problem plus one more: the Reference command under Tool is dim and cannot be activated? "Idoia" wrote: That worked, thanks a lot. "Gary''s Student" wrote: From VBE: Tools > References > check SOLVER -- Gary''s Student - gsnu200760 ... 21 May 2010 19:28

Need Help Search and Add
Have a 2 rows of cells (5 and 6) with data. Row 5 has letters A through S. Row 6 has years 2001 through 2018. In addition, I have Cell A14 where I would like my users to type a letter from A through S. Based on the letter entered in A14 I would like excel to search row 6 and find the correspondant year and ente... 25 May 2010 10:13