10063 posts
7063 users
Peter Batchelor wrote : > Only one file (to my knowledge) cannot accept the INSERT > command from the menu bar in my Office 98 version of Excel. > Unfortunately, it happens to be an important one. I...

Things this newbie doesn't know
2 replies , 8/9/2003, 4:23:55 PM
I bought Office X shortly after buying my new PowerBook this past February. Previously, I'd used Excel off and on with a pc at work - enough to get the job done without having a clue what I was...

list of functions
1 replies , 8/10/2003, 1:21:12 AM
Is there somewhere in Excel Help or elsewhere in the program that lists all the functions available for formulas? I've found lists of "Math and Trigonometric functions," "Lookup and Reference...

Office Update and Excel web queries
1 replies , 8/10/2003, 8:21:57 AM
Since installing the last update, I find that my excel sheets with web queries don't seem to work any longer : Excel quits at the end of the "loading data from web" time. If I open from the finder...

Random Number function
2 replies , 8/10/2003, 8:54:47 PM
I want to use the RAND and RANDBETWEEN functions but don't want the numbers to change every time a calculation occurs. Can this be done. I'm using Excel included in Office:mac v.X

Ed Schillmoeller
On 8/9/03 10:21 PM, in article O******************2MSFTNGP09.phx.gbl, "Jim Gordon" <g**********otmail.com> wrote: > Hi kevs, > > Try visiting the Page Setup and check to see if it set to print at...

ODBC, Excel2001, and Classic
4 replies , 8/11/2003, 8:36:56 PM
I'm running Excel 2001 under Classic (9.2.2) on a Mac running OS X 10.2.6. Whenever I try to set up ODBC via the ODBC Setup PPC control panel, I get nothing. In the User DSN tab I click "add",...

Doug Starkey
6 replies , 8/11/2003, 10:56:02 PM
Doing my first foray into Excel macros. I called my macro called "zoom 200" 1)Excel said name is no good, what's the rule with that? 2)Excel defaults shortcut keys to option command, blank, I...

displaying a builtin dialog box
1 replies , 8/12/2003, 4:49:43 AM
I am attempting to display Excel's builtin SaveAs dialog box. The following code displays the Dialog correctly: Application.Dialogs(xlDialogSaveAs).Show However, I get an error...

Font question
5 replies , 8/12/2003, 7:41:52 PM
Could someone please give me the definitive lowdown on setting small size fonts? From what I see in the toolbar and formatting palette, the lowest number on the drop down menu is 9. For some...

1 replies , 8/12/2003, 8:55:56 PM
I'm using Excel X. 1. I almost always use the Function Palette when entering a function since I'm less likely to make a mistake. The Palette opens in the upper left corner of the worksheet. Is there...

Ed Schillmoeller
Snapshot and Print Preview Crashing
3 replies , 8/12/2003, 9:00:29 PM
I have discovered a reproducible bug in Excel (version 10.1.0 (2015)and newer) on Mac OS X (10.2.2,3,4,5,6). The bug causes Excel to "Unexpectedly Quit" and I have been able to reproduce it on...

Copying from sheet to sheet
1 replies , 8/12/2003, 9:14:03 PM
Range B3:C9 is named �ProjectDetails� in the sheet named �Schedule� I need to copy the ProjectDetails from time to time into the sheet named �List� as the macros steps Recording the macro I...

Francis Hookham
Simple Macro's
1 replies , 8/13/2003, 10:35:11 AM
Hi, I need some help creating 2 excel macros. Macro 1: Convert an Excel spreadsheet held on an NT Server from "normal" XLS format to CSV format via an Excel macro Macro 2: Convert the CSV file...

Drop-down menu
1 replies , 8/14/2003, 5:59:46 AM
In a cell with a list of values/choices in a drop-down menu, is there a keyboard shortcut that automatically displays the menu? I always have to use the mouse to click on the arrows to get the menu...

Consistent Excel X crashes......
0 replies , 8/14/2003, 6:37:24 PM
Current System config: Excel 10.1.4 (meaning that I have the 10.1.4 update installed) OSX 10.2.6 784 MB RAM 16 GB free disk space (according to the Finder) Single partition, all files and apps in...

First/last row/col
1 replies , 8/14/2003, 9:34:38 PM
First/last row/col I am getting in a terrible muddle trying to find the first and last occupied row in a particular col and in a row in a particular col In this particular project data is stored in...

Francis Hookham
Toggling buttons
3 replies , 8/14/2003, 9:35:27 PM
Toggling buttons I often use Autoshape buttons and assigned macros to them - when the button is used to toggle (Protect/Unprotect) then the colour and/or wording on the button is changed - ok, that...

Francis Hookham
Observing macros calculating
1 replies , 8/15/2003, 8:05:33 PM
Used to be that in Excel4 Macros, if you were stepping through a macro, you could watch the macro calculate an expression. eg. "=FORMULA("=4*r38c2*453.59237/128/(1+r39c2)" could be watched as...

Doug Starkey
Getting data from last item in list
0 replies , 8/16/2003, 3:39:41 AM
I have a workbook with a list on the first worksheet. The column settings for A are Data Type = Counter. The count is currently at 25 In column G (7th column) is a number I need in Row 26....