General

Is there a fix for the slowness in excel 2007?
I have the same issues at Jon seems to have. If I understand what everyone has written, there is no fix, 2007 is just half as fast as previous versions? "Jon Peltier" wrote: This is true, but his stats come a bit further after he says it doesn't matter in Classic Excel. - Jon ------- Jon Pel... 7 Jul 2008 12:30

Status Tool Bar and "Calculate"
I am trying to find out how to remove "Calculate" from showing up in my status tool bar. It is not enabling me to actually calculate or sum up any cells. Every time I try and add/sub/multiply/div if the 'calculate' is showing in my status tool bar it gives me a ZERO total? ... 7 Jul 2008 13:32

Lookups
I have a table of data that I need to cross reference to get a cell value but I can't seem to be able to. The table has gate sizes Height and Width with different combinations using different sizes of gate posts e.g. the heights are in the first column and the widths in the first row how would I get the value o... 9 Jul 2008 11:39

Filter Criteria - Excel 2007
I'm trying to show the filter criteria when printing. I've seen VBA code by several MVP's, and all work great as far as showing the criteria in a cell in the worksheet. I've written code in the ThisWorkbook object using the BeforePrint event to put the values in a header, but I'm limited to only 2 criteria. ... 7 Jul 2008 11:28

Control Data Entry - push entry to next cell
Good morning! I have created a spreadsheet with three columns. Col A is Tally#. It is an autonumber 1-200. Column B is Length. The data for Length is not entered using the keyboard. It is entered via blue-tooth from a laser distance meter. Column C is a running total. I have protected Column A and Colum... 7 Jul 2008 11:28

Display contents of associated cells
Hi, If I have a rule in (say) cell B2 to deliver a a specific piece of information, how would I consider composing an alternate rule that displays the content of another cell aligned with it eg if(ruleB2=TRUE) then display contents of C2 ... Does that make sense ;( Don- ... 7 Jul 2008 12:30

Download link ok?
I found what I thought would be a useful file (it's supposed to show the various custom format options in Excel), but it's an application and the recommendation came from a non-microsoft website. Any ideas if it's trustworthy? Here's the URL: http://download.microsoft.com/download/excel97win/sample/1.0/WIN98Me/... 7 Jul 2008 17:39

Custom Format
I would like to use a custom format that will take a number/text string like: 1405828AB And convert it to: 140N-58W-28-AB Where the N and W are fixed, but the "AB" can be any combination of two of the following four letters A, B, C, D. I have a version that works for everything but the letters at the e... 7 Jul 2008 15:36

Fluent UI and protect workbook with password
This issue has to deal with adding a Fluent UI tab according to the procedures at: http://msdn.microsoft.com/en-us/library/aa338202.aspx The section I'm referring to is under the title: “To customize the Fluent UI by using Office Open XML Formats files“. This works according to article, however, if we go to... 7 Jul 2008 13:32

Insert Function next to formula bar gives Run-time Error '50290'
Greetings, Background: We are using Office 2007 Pro Plus on XP SP2. We have a basic XLSM file with the following Macro code: Sub auto_open() Application.OnEntry = "ChangeStatus" End Sub Sub ChangeStatus() Application.StatusBar = "Changing formula" & Now End Sub When opening the file, we clic... 7 Jul 2008 11:28