Windows Secrets
Windows Secrets Lounge
Excel cell refs to other Excel files (XP)
Draft over page (Excel 2000)
Cell Control for show/noshow (Excel 97)
Best Excel web sites for VBA knitty gritty (Excel 97 and up)
What's the cell format? (2000)
Excel Shortcuts broken (Office 2000)
Superscript character in cell (Excel xp)
Excel crashes when copying sheet (97 sp2)
Rows to Columns (2002/XP)
Locking Cells (All)
Lunar calendar? (2002-XP)
CONDITIONS (2000)
Calculate N Years Inflation (Excel 97-SR2)
Obtaining Cell Address from Input Box (Excel XP)
Text Word Wrap (97 SR-2)
Validation from Lists (Excel 2002)
Multiple Sumif (Excel 97)
Converting Cell Formats (2000/SR-1)
Excel Formula (Excel 97 SR2)
MS Query into Excel has suddenly gotten really slo (2000)
Vlookup (Excel 97)
SUMIF and change in a cell (Excel 2000)
Custom graph (Excel xp)
Remove IF? (Excel-97-SR2)
Charting only non-zero values in a range (2000)
Controlling Keyboard Keys (Excel 97 SR-2)
'Help' listing for parse (XP and 2000)
Excel Function- Between two values (Excel 2000)
Testing For Zero (Excel 97-SR2)
caller address - worksheet? (2000 / VBA)
Removing Duplicate Rows (Excel 97) (Excel 97)
Trendline (Excel 2000 SR2)
Calendar help (97/2k)
vlookup including the comment (excel 97)
Referring to a checkbox control on a worksheet (Excel 2000/2002)
Formula to reference a cell based on another cell (Excel xp)
Calculating Time Sheets (Excel 2000)
DSUM criteria problem (97 SR-2)
NUMSONLY function (Excel XP)
Numbers with asterisks (Excel xp)
Autoname Workbook (97)
The Big 'X' (Excel 2000 sr1)
Renaming Sheets (Excel 2K/XP)
Pivot Table (2000)
BIG BOO BOO (Excel 2000)
Count if and (XP)
Complicated IF/Then (Excel xp)
Linking Worksheets (Excel 2002)
Help! Save xla to xls (2000)
Move/Copy Worksheet (Excel 97-SR2)
Global Macros (Office XP)
Custom menu changes path with macros on SaveAs (Excel xp)
Array function oddity (Excel 2000 SR1)
Delete empty columns if not equal to .5 (Excel xp)
Delete empty rows (Excel xp)
Command Button behavior in Excel 2000 (2000)
Difference of Private, Public or Just Sub (Excel xp)
Three Dimensional Plot (97)
excel workbooks (windows xp)
if formula (XP)
Delete Sheet Macro (Excel 97)
Selective Cell input (97)
Autofilter (Excel 2000)
Excel Chart Axes (2000)
Worksheet name without slashes (Excel XP)
Search for text, cut and paste to another sheet (Excel xp)
Test for Cancel of SaveAs Dialog (XL2000)
sum ignore '#VALUE!' (Office 97 SR2)
POP to show picture (Office 98)
Convert poorly formed text dates into XL dates (Excel 97)
Splitting apart one chunk into columns (Excel xp)
Floating Control (Excel '97 SR2)
Settiing 1 range equal to another (2000/2002)
Pivot Table Error Message (2000 SR-2)
Not Recalculating after upgrade to Win2K (2000)
Text Box Distortion Upon Deletion of Rows (2000)
The problem with blanks (2000sr1a)
excel header date question' (excel xp)
Prevent user from selecting a cell (97)
Workbook is Locked (Excel2k SR1a)
Task Pane SHOWING on startup! (Excel xp - )
Adding Add-IN programmatically (2002)
Test Questions (MS-Excel 97-2002)
Printing a Word Doc (excel 97)
Complex Summing Problem (XP SP-2)
Shorter Concatenation (Excel97-SR2)
Update to Name manager (97 2000 2002)
Excel Summarize Time (97)
Argument Descriptions (XL2000 )
Accessing Word options from Excel (2000)
File Size Again... (Excel 97-SR2)
Empty cells until typed in (Excel 2000)
Calculate message on status bar (97SR1)
Compare Oddity/Rounding (Excel 97-SR2)
losing custom date format (97 sr2)
Odd and Even Row Extraction (XP)
Find the remainder of a list (Excel 2000)
odd #value! (2000 SR1)
Pass cell address to fn (dumb q #327) (2000sr1a)
Range Name Across Multi-Worksheets? (Excel 97-SR2)
Custom Views (Excel 2000)
Slow Activation after WorkBook Is Open (Excel 2000)
Dynamic Print Area (Excel 97-SR2)
Calculate External References (Excel 97-SR2)
CTRL-End sends me too far away. (Office 97 SR2)
Grabbing Offset (Excel 97 SR1 NT4)
Flexi Time calculator (2000)
Testing Date Ranges in Excel (97)
SUMIF and cell references (Excel 2000)
Command buttons (XL 97 SR2)
Automatic Functions (Excel 2000 SR2)
ToolBar & Windows Explorer (97:SR2)
Adding and subtracting with conditionals (Excel 2000 SR-1)
Cannot empty clipboard (Excel 2000)
Conditional formatting (Excel 2000)
Conditional Custom Functions (2000/2002)
Excel 97 in XP O/S (97 no sr)
Scatter Graph (Excel 97 SR2)
Advanced sort in Excel (Excel xp)
Naming Excel Sheets (Excel xp)
MIssing cell contents in PDF (Excel 2000 Acrobat 5)
Formula Assistance (97;SR2)
How to determine cell when function is used (2000/2002)
Macros in custom menu (Excel xp)
Pivot table and zeros (Excel 2000)
Need Help with automatical copy, paste then sum (Exel 2000)
Adding a row automatically (2000)
Numbered forms (xl97)
custom formats (2000)
Excel Bullets (Excel 97)
Excel (97 SR2)
Unloading a Macro (2000)
Print Setup Automation (97 SR2)
Record count divided by time? (Excel 97)
How to get a count of cells with formulas (2000/XP)
Formula for Filename (XL 97)
data netry cell order? (2002 - XP)
Looping through cells in a range (2000/XP)
Hyperlink Embedded in a Cell (Excel - W2K & 2002)
Printing Macro (2000)
Doc created from .xlt jumps to 7MB on one PC only (2000/SR2)
Excel Macro activating workbooks (Excel 2000)
Macro: print each sheet to pdf using sheet name as (Excel 97 sr-2 Win95)
Either/Or (2000)
Conditional Formatting (2000)
Track Changes (Excel 2002)
Validate Loop (Excel 97)
String code to bold face lines (Excel xp)
Excel files in IE (XL2000)
Range Names (Excel 2000)
List box directly in cell and not on form (Office 97)
re:Making the enter key work on a UserForm (XP)
Pasting RTF format text in Excel (Office 97+)
fill series in filter mode (excel 97)
Problem with Cells.Replace via OLE call (Excel 2000)
Adjusting Cell Margins (W2K / Excel 2K, SR1)
VLOOKUP & Combobox (Excel 2002)
Unhide Row Problem (Excel 2000 SR-1)
formula to make text all caps? (XP)
Error when trying to send from Excel (97)
Text color (Excel 2002)
manual calc is default (XL 97 sr2 on Win 98)
Shade cell in one sheet based on another sheet (Excel xp)
Workdays Formula (2000)
Platform Upgrade (97 SR2)
Excel 97 (Win95, Office 97)
Files list in VBA (97/2000)
Chart label - alter with autofilter (97)
Workbook/sheet reference (Excel XP)
Show Formula in Specific Cell (Excel 2000)
How big is BIG spreadsheet? (Excel 97-SR2)
Date formats (2000)
Default Color (Office Xp)
Insert CR/LF In Text? (Excel 97-SR2)
Loooonng String Concatenation? (Excel 97-SR2)
Assign Range Name (Excel 2000)
resource tracking chart (Office 2000, MS Exchange Server)
Repeating Rows during Print (2000)
ChangeLink Command (w2kO2ksr1)
Need to make a survey? (2000)
BUG IN NAME MANAGER SETUP (97, 2000, XP)
controlling chart position in same sheet (Excel 2002)
ChangeLink Reference error (w2kO2ksr1)
Filter Drop Down (Excel 2000)
WebQuery question (Excel 97)
Dos Style Text Box (97 SR2)
TREND/GROWTH/OTHER? (Excel 97-SR2)
Visio import of Excel data (Excel 97 SR2 WinNT Visio 2002)
Counting filtered rows (XL97, WinNT4)
SUM Nth Column in Array (Excel 97-SR2)
Auto backup of open Workbook - again ! (Excel 2000)
Specific column width (any?)
personal.xls (2002 (10.2614.3311))
Drop Down in Excel (Excel 2000)
Sorting odd and even (2000)
Date calculation difficulties in macro (2002 SP/2)
Macro for Book.xlt and Sheet.xlt (2000)
Rows & Columns (Excel 2002)
Import Spanish data into English spreadsheet (Excell XP)
Sorting Dates (Excel 97-SR2)
Canadian Mortgage Schedule (2000)
Liniks - Linked document now corrupt (Excel 2000)
Name manager, released. (97, 2000, XP)
Remove outside links (Office 2000 SP2)
Saved file won't open (97 SR-2)
Font of Autofilter (XL97)
Macros in workbook (2000)
Excel Causing Crashes (Excel2000 sr1)
Is C a reserved Name? (2002)
Worksheet function (not VBA function) Randomize (Excel)
Excel Footer Font Size (2000)
Run macros automaticly (Office 2000)
Merging Workbooks (97 SR2)
Excel Workbooks (Excel 2000)
Group & Outline, crashes on Hide Detail (2K)
Column widths in multiple worksheets (all)
Default Styles (Excel XP)
Now() Function (2000)
Conditional formatting based on reow visibility (97+)
XL97 File Unretrievable from Floppy (97 (NT4 OS))
Auto Update Comments (Excel 97-SR2)
Excel Window will not maximise (Excel 2002)
VLookup in Array Formula (XL2KSR1)
reverse cell contents (excell/97-2000)
Calculating Formulas in SUMIF/COUNTIF? (Excel 97-SR2)
digital dashboard & excel (Excel 2002)
Name that Shape (97+)
# Error on text (2000/sr1)
&[TAB] (2k2SP2)
Can you run code when cells change (2002)
Comment Distortions (w2kO2ksr1)
Recently opened list (2000)
Basic accounting programme (Excel 2000)
Save warning message in Excel 97 (97 and 2002)
Delete unique rows, leaving only dups (Excel 97/98
Auto Filter (2000)
Color Print Preview (excel2002)
Find Macro and find link (2000)
Name manager -getting closer- (97, 2000, XP)
Sorted ListBox and CursorWait (XL2002)
Importing fixed-width text (2000/sr1)
Pivot Table Calculated Fields (97)
Finding field name for the maximum value (2000)
Display Progress in a Userform (2000)
Userform showing text after being displayed (2000)
Comment Alternative (Excel 2000 SR1)
Row Elimination Macro (2000 SR-1)
Converting Lotus macros (Excel 2000)
Function equivalent to 'text to columns' (xp or 2000)
Day of Week as single letter (E2K)
INDIRECT Function Alternatives? (XP/SP2)
Equivalent Code (XL97:SR2)
Building Userforms (97)
Calculate documentation error (w2kO2ksr1)
Sharing/Saving Files (Excel 2000)
Excel 2000 Date conversion (Excel 2000 SR-1)
Nest functions inside OFFSET function (Excel XP)
Breaking VBA code (2000)
Insert Word doc to Excel (Excel97)
Mapping Software
golf: counting my pars etc. (97)
Unexpected Defined Names (w2kO2ksr1)
Triggering Recalc (w2kO2ksr1)
Drawing Text Boxes: Show results of formula ? (W2
Deleting specific shapes (2000)
How 2 Run Xl From Bat file and .. (Xl '97 up)
Excel 4 Macro in 97 Worksheet (97)
Hiding rows without selecting them (2002)
Built-in Footers (Excel 2000 / SR-1)
Addin for daigrams (Excel 2002)
Separating Date/Time (97 SR2)
Please help w/Macro to position cell focus (Office 2000 SP1)
UserForm QueryClose (2000)
Smart Tags (Excel XP/SP 2)
deleting links (97)
Making Curves (w2kO2ksr1)
Is there a 'Scroll' event for Excel worksheets? (Excel 2000 SR1)
Searching through dates (2000)
SUMIF??? (Excel 97)
MAX function (XL97)
Named Pivot tables (Excel 97)
Zero and Blanks (2000)
Name Manager (97/2000/2002)
seven becomes eight (XL97 sr2 on Win NT4)
Parsing Problems (Excel 97 SR2)
Date Format & Day Of Year (2000)
Heating Degree Days (2000)
Excel Add-In (2000)
Can't close Excel with X (97 SR2)
Bullet or Numbered List (Excel XP)
Pop-Up Toolbar Button (Like the Borders Button) (Excel 2000 SR1)
Can't change page breaks (2000)
IF Function in Formula (2000)
Week # dates (MS Office 97 SR1)
Password protected file (Excel 2k)
which financial function? (excel 97 sr2)
Calling Macro from one workbook to another (Xl '97 on..)
Hooking into an AddIn (2000/XP)
Absolute Values ABS in SUM (Excel 2000)
Range Syntax (2000)
Excel graphs linked to Powerpoint (Excel 97/2000)
No. of Filter Items (Excel 2000)
Rank Function (Office 2000)
Drawing a circle with a macro (Excel 2000)
Mathematica (95, 97, or 2000)
grab delete (excel xp)
AfterRefresh event of a QueryTable (XP)
Format Millions (2000 SR2)
Which Function (2000)
hidiing tabs (Excel Xp)
Array Dates min and max (97/2000/XP)
Syntax Error (2kSR1)
help needed in excel (excel 2002)
Disappering Tabs (Office 97)
Excel (2000)
Deleting rows based on specific criteria (Office 97/SR2)
Variables (XL97:SR2)
Saving copies automatically (XL97/WinNT)
Use results of 1 cell to be formula for other cell (2000)
Excel Users Anonymous (Excel)
Subtotals Just Don't Add Up (XL97:SR2)
Help with dates (excel 2000)
Pasting Excel into Outlook (Excel 2000) (180155) was moved to the Outlook board
Insert exact same text inbetween every line (Excel 2000)
Sorting Items On Different Worksheets (2000)
returning to where I came from (XL97 Sr2 on Win 2000/NT4)
automaticinsertion of date and time (2000)
Best Excel VBA book (All)
Password Protect Excel 2000 (Excel 2000)
Insert Object (Excel97)
Changing a number field to a text (Excel 2000)
duplicate records (excel 2000)
Print incrementing date (2000/9.0.3821 SR1)
Lookups / Match (Excel 2000)
Date/time picker (DTPicker) (EXCEL 97/2000)
Excel open in a explorer window (200 sr1)
Disable Alert Display? (2002)
Error Checkin and Dependant Data Validation List (Excel XP)
Working with Flat files in Excel (2000)
Custom Functions - Determining the 'Calling Cell' (Excel97)
Using UDFs on multiple PCs/Macs (Excel 97/98/2000)
Default file format (2000 SR1)
Count On SubTotals (XL97;SR2)
Sorting by Color (Excel VB )
VBA to see if a Workbook is Open (97+)
Excel series with datalabels from different column (Excel xp)
Sorting WSheet by Name (Excel 2000)
Date formula problem (Excel 2000)
Paste Special Using Drag and Drop (Excel 2000)
Control Toolbox Objects (XL97;SR2)
Two Variable Data Table Oddity (XP - SR2)
Disappearing Add-In (Excel 2002 SP-1)
Font size for comments (97)
Counting cells that contain certian text (Excel 2K)
Hyperlinking a Query (Excel 2K)
Sorting by Code (Excel 2K sr1a)
Cell value not recalculating (Excel 2000 SR1)
Printing an object (xl2000 sr1)
formula (Excel 2000)
Avoiding Circular References (Excel 98/2000)
Chart 3 columns, 1line (Excel 2002)
Special format codes in header (2000)
Formatting Subtotals (Excel 2000 SR1)
Lost Cancel Button (2000)
WorkSheet macro problem (Excel 2000)
Saved Dated? (97SR2)
Sequence of updating links (XL2002)
Cancel BeforePrint Event? (2000/SR-1)
Conditional Format Significant Digits (XL5)
Format Cell for Euros (97 SR-2)
Change Worksheet Names by Function/VBA? (2000)
BuiltinDocumentProperties('Revision Number') (97 +)
Multiple Criteria (97 SR2 )
Print Active Sheet(s) with Code? (2000-SR1)
VBA Scroll into View (XL 97)
numbers-to-text (xl 97 sr2)
Dumb Chart Question, Why Some Bigger (97)
Using Excel 2000 with a FTP server (Excel 2000)
Set chart data programmatically (XP SP1)
Find/Replace * (Excel 2002)
Hiding a macro (2000)
Custom Printing (2000)
What the??! Incorrect Totals... (2002)
Running Totals (2000/SR1-a)
Pause-Resume Macro (XP)
That Sums It Up (XL97:SR2)
Calculated filenames in function arguments (Office XP)
manual page breaks (office 2002-sp2)
Copy Worksheets & Links Change (Excel SR-1)
Array Formula (XL97:SR2)
Protection vs. copy/paste (2000 SR1)
VLookup (Office97 SR-2b)
How do you clean up bloated workbooks? (Excel 2000 SP1a)
Global Formats (Excel 97 sr2)
Pivot Table Help (Excel 2000 SR1)
wrapping a custom date format (2000)
MsgBox Command (97 SR2 VBA)
Do you use a multicell array for this?? (Excel 97)
Opening Files (Excel 2000)
User Defined Functions (Excel XP)
sorting and protection (XL 97 SR2 on Win 2000)
Smart Options/autofill (Excel XP)
What is in a Name (XL97:SR2)
Conditional Formatting (Excel 2000)
Additive Selection (2000)
Chart datalabels (Excel xp)
When recording a macro doesn't work... (XP/SP2)
Data Entry Forms (Windows 2000 OP)
Changing Remote Links (2000)
Freeze Panes (97)
Copying From A Web Page (2000)
PSpecial problem (XL2000 SR1)
Scroll Feature (Excel 2000/ Windows 2000)
Formatting of % in Excel (Excel 2002)
UNC Address of a file (Excel97)
buttons on a page (excel 2000)
freezing a line (excel 2000)
Excel - Copy Sheets Problem (Excel 2000 SP2)
XL95 Dialog Sheets (XL97 & XL2000)
Is there a way to display recently used files? (XP)
Creating submenus in VBA (97/2000)
Excel4Macro Help File (97/2000)
Identify chart name via VBA (97/2000)
Force loading of New Excel Copy on file open (Excel97)
Combobox selection (MSOFFICE XP)
Copy/Paste Macro between Spreadsheets (Excel 97 SR2)
Match and get related data (excel 97)
Using text in one column to id values in another? (Excel XP)
Selecting Records (Excel 2000)
VBA Userform textbox date and time (97-XP)
Autofile at 2 levels (excel 2002)
Protect Cells w/o disabling Sort or Col Width (2000)
Open File from Form (Excel 2000)
Excel VBA/Macros (Excel 2000)
Password on open error (excel 97)
Excel and Word (office 2000)
Phone Numbers (Excel 2002 SP1)
Select worksheets from a pull-down menu? (2002)
Excel comments (Office 2000)
Excel worksheet appears on startup (97 Sr2 on Win2k)
macro run time error (Excel 2000)
Picture BMP (Excel 2000)
SendMail (Excel 2000)
numeric formatting without decimal point (XL2000)
VBA for copy and paste (Excel 2000)
Pivot table macro (Excel 2000)
update a scale on a chart (2000)
Delet astericks (Excel 2000)
VBA code to delete blank rows (Excel 2000)
Reference Types (2000)
Function book (XL2000)
Pop up tool tips? (Excel 2000)
File Open (Excel 2000)
Linking with access (XP)
drop-down boxes (Excel 97 SR-2)
Line breaks in a Label (2000)
Excel 2000 (2000)
Creating a hyperlink with a macro (97/2000)
Percentage (Excel 2000)
Sum a Range (2000)
MRU problem (2000/SR-1)
Excel's (Normal.Dot) (97 SR2)
Listbox behaviour (Xl 2002)
If Not Found (97 SR2)
Back to DOS (system) (Excel 97)
Autofill (Office 97 SR2)
Excel Top 10 list (97 SR-2)
Excel VBA problem (XL2000 SR1)
Bordering Cells Macro (Excel 2002 SP2)
Export a Toolbar (Excel 2000 SR1a)
Remove Autocomplete Entries (Excel XP)
Using Open dialog box (Win 98 SE Office 2K)
Emailed workbook won't update (Xls 97)
Never place hyperlink (Excel 2000)
SUMIF with Multiple Criteria (97)
unsuccessful in plotting time series (XP)
Custom Cells (Excel 2000)
Radio Buttons - How To? (97 SR2)
Naming sheets automatically (Excel 97)
Calculation Hangs in Excel XP (XP 10.2614)
2 Questions/Problems (2000)
What are the odds? (2000)
FOOTER'S DATE (97)
Help with Formula(s) (Excel 2000)
Split text into 2 cols (97)
Batch number (Excel 2000)
Excel connecting to MSProject (2000)
Sales, Tables & Arrays... Oh My! (97)
Count Worksheets (97 & 2000)
Search Woes (97 SR2)
Analysis Toolpak - VBA (Excel 2000 SR1)
Goal Seek Problem (Excel 2000)
Apostrophe (Excel 2000)
Read cell color while importing into access (Excel 2000)
VBA is a file already open (Excel 2000)
trailing letters on numbers imported from other ap (2000)
Copy Personal.xls (off 2000 SR1)
Excel Fonts (97sr2)
Circles in Excel print oval?!? (Excel NT4 & Win2000)
Excel Hanging (Office XP Professional 2002)