General

Unable to make a pivot table in sheet2
Hi, Can someone pls check below code. I'm able to export a query from access to excel in file "Myfile.xls" sheet1 but unable to make a sheet2 with pivot table of sheet1 data. Option Compare Database Public Sub TransferReport() Dim varFileName As String Dim xlApp As Object Dim xlWb As Object Dim xlWs As O... 10 Jan 2010 14:08

hide #div/0
i need to hide #div/0 error for the following formula = PMT(E6/12,F6,E4) when result is =0 I used IF(ISERROR (PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4)) IF(ISERROR(PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4)) IF(ISERROR PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4) IF(ISERROR (PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4))) nothing is ... 9 Jan 2010 22:54

Using "sort" in auto filter not possible when protected?
I have a sheet that is protected and uses autofilter. The "Allow Autofilter" box is checked and autofilter does work when protected. However, in the autofilter drop-down box, if I choose sort ascending or descending, it will not. I have also tried checking the "Allow Sort" box - no luck. Is it possible to sort ... 9 Jan 2010 21:49

Formatting rows
I want white and shaded alternate rows, but not in the simple one-on one-off pattern. My spreadsheet is sorted by date in Column A. I may have 10 rows with a date of 01/09/2010, then one row with 01/10/2010, then 20 rows with 01/11/2010...you get the idea. I want all rows with a given date shaded, then a... 15 Jan 2010 12:44

How do I customize hotkeys for excel 2007?
For some reason when I press the "Enter" key it no longer selects the cell below. It stays in the same cell. This is driving me crazy! How do I get the "Enter" key to perform the default function again? ... 9 Jan 2010 18:32

What is office connect?
How does it work? ... 9 Jan 2010 16:18

Excel 2007 workbook
Is there a way to duplex print an Excel workbook with 12 sheets? In other words have 6 pages of finished print-out. I've tried every setting I can on my HP CLJ 3800 (Win XP Pro), to no avail. :( ... 9 Jan 2010 16:18

Getting Excel to return Hiragana using code/char functions
I have a Japanese computer which does this perfectly, but when I tried to use the worksheet on an English computer with Japanese language enabled, it only came up with errors. The code it was returning for the Japanese characters was much to low & putting in higher codes meant it didn`t recognise it. What can I ... 9 Jan 2010 08:32

Unhide Column
Yes, to unhide a column would seem to be a basic task. However, my wife sent me a file from work that has column C hidden. I used the "right-click, unhide" method, but it didn't work. The file is not read-only. Is there another way to unhide a column, or am I just missing something? As usual, thank you eve... 11 Jan 2010 14:16

Update Links Slow
My supervisor just showed me a monthly process I am to inherit. Basically it involves these steps: 1. Copy Last month's files to This month's folder. 2. Rename the files. 3. Update the links to point to the new-name files instead of the files in last month's folder with last month's name. She says that to... 8 Jan 2010 18:28