General

vba converters
I'm obtaininig an error that requires a "VBA converter" when I load an old add-in in Excel 2007. How could I fix this problem? ... 25 Nov 2009 21:44

Pasting into a filtered sheet
I have an Excel spreadsheet where some of the rows are not visible as they are auto-filtered out. I have a column of 20 cells from another sheet that I want to paste in to cells in the top 20 visible rows of the first sheet. However, whenever I try this using Paste or Paste Values, it fills the top 20 cells in... 25 Nov 2009 16:06

Excel Hyperlinks Broken After Windows Update 11/25
I left an Excel document open, not realizing Windows update would be restarting my computer while I was gone. When I got back, my file had reopened (autosave), but when I click on a Hyperlink (to a .tif file in the same folder), I get the message: "cannot open the specified file". This is a 36,000 row documen... 25 Nov 2009 13:49

Excel Renaming Files When Opening Using File Convertor
We have a user using MS Office 2003 SP3 (Windows XP), with the File Format Convertor installed for Office 2007 files. When he opens an Excel 2007 .xlsx file, Excel 2003 launchs, the File Convertor does it's work and opens the file, but the file name changes completely, the filename will follow the format Xl0000... 25 Nov 2009 11:31

cross hair
i am a teacher and use excell for grades . Names on top assignments on the right side. i am trying to make cross hairs what ever cell i click into i will see a color line vertical and horsonal to help me make sure the right grades are entered. i have office 2007 pro. -- Mr. Coffee ... 24 Nov 2009 08:54

Outlook 2007 crashes
Hi, AppName: outlook.exe AppVer: 12.0.4518.1014 AppStamp:4542840f ModName: outlfltr.dll ModVer: 12.0.4326.0 ModStamp:44c81343 fDebug: 0 Offset: 0004acff I get the above error and outlook 2007 closes and restarts and same mail repeatedly downloading. As a result I am not able to read an... 22 Nov 2009 09:24

Copy sheet to different workbook sizing error message
When trying to create a copy of a worksheet and inserting into a different workbook I receive this error message: excell cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. Goes on to tell me to C&P into other workbook which I don't want t... 20 Nov 2009 16:52

Excel 2007 Traffic Light with dates
I’m trying to use the conditional formatting, traffic light feature with dates and am finding the new Edit Formula Rule app to be rather limiting. Hopefully it’s just my ignorance. Cell E1 contains current date (updated when the workbook is opened) several other cells have fixed expiration dates. In the expira... 23 Nov 2009 11:53

Autofiltr w Tabeli z formułą w kolumnie funkcjonuje błędnie
Excel 2007. W pierwszej kolumnie tabeli wprowadzono formułę obliczającą liczbę porządkową, by po wyfiltrowaniu nieaktywnych klientów numeracja nie zawierała uskoków. Sposobów na obliczanie kolejnych liczb porządkowych jest wiele i bez względu na rodzaj formuły po wstawieniu trywialnego autofiltru, prócz rekordó... 20 Nov 2009 10:05

Spontaneous format changes in Excel
I have a user who says that he experiences spontaneous format changes in MS Excel when he is working in his Monthly Receivables Analysis 2009 workbook. Every month beginning with the start of the fiscal year, he adds more data into the workbook so the size of the workbook grows continually until the end of the ... 20 Nov 2009 08:58