Windows Secrets
Windows Secrets Lounge
blecch - comparing columns of data (Excel 97 SR2)
Excel - check how many instances are running (97)
Define Name (office 97 SR2)
Replace dash with a blank cell (excel 2000)
DialogSheets/Edit Boxes (Excel 2000)
Export/Save a report to a file (Office 97, Excel 97 & Compaq printer)
Changing Tab Color (XL 97; SR2)
IF(OR) (2000)
Pivot Table (Excele2000)
Excel Star Posts (All Versions)
Email Excel Spreadsheets (Excel 2000)
Mail Merge (E2000 W98SE)
Combine text frm 2 different cells into One cell (excel 2000)
Using ActiveSheet.UsedRange to define a print rang (Excel 97)
Saving a Value from one run to another (MSOFFICE97 SR2)
Disable "X" Box On UserForms (2000)
formula to calculate date in years and months (Excel 2000 SR1)
How to set 1-row Range with Variable # of Columns (Office97 SR2)
Template (2000, SR-1)
Lotus Conversion (Excel 2000)
Not displaying #N/A within an Array formula (Excel 97)
how to make functions (2000 sr-1)
Formula (2000)
custom stuff (2000 sr-1)
Change Range Names wo Asking User (OFFICE97 SR2)
Insert with Formula (Excel V97)
How do I get started in VB (Excel 2000 SR-1)
Names applicable to several sheets? (2000 SR-1)
Transfering Data Into Corresponding Fields (Excel 2000)
How do I close a Print Preview window from code? (97)
Seeking better way to 'fill" formulas (Excel 2000 SR-1)
How to Add Time Together (Excel 2000)
Useful Excel Customizations (Excel 2000/97)
Useful Excel Spreadsheets (97)
Limit number of decimals in a cell (Office 97 SR2)
View PageBreaks (Excel2000)
Vlookup Problem (excel 2000)
Xmas Tree (Any)
Copying a range freezes computer (2000 / SR-1 and SR-2)
DSum Formula (XL 97; SR-2)
Auto calculation (XP)
Menu Code Question (XL97SR2h)
General: For Loops (2000)
Header/Footer Defaults (Excel 97)
VLookup Case Sensative (SR-1)
Loan Amortization/Billing and Tracking (XL97; SR-2)
chdir in vba (2000/97)
dsum function (Excel 2000)
Delete a specific word in a column (excel 2000)
Year 1900 Err in Excel2000SR1 (OSWin NT-6)
Format cell won't open (Excel 2000)
vlookup question (v97 sp2)
Speedy Routine (xl2000)
Unexpected #Name error (XP)
COUNTIF "H" and "h" (2000/2002)
opening a workbook (2000)
Printing Really Wide Sheets on Regular Paper (2000)
Query problems (Excel 97 & Access 97)
Previewing a file with a Userform (XL2000 SR1)
3D data (97 SR1)
Arrays in Excel XP (XP)
Check to see if File is Open (OFFICE97 SR2)
Mouse Cursor during macros (2000)
Macro mailing (2000-sr-1)
Weird printing problem (Excel 97 on OS 95)
Loosing my links (Office 97)
Appending txt file to an existing spreadsheet (2000 SR1)
Array problem (xls 97)
printing a form (2000-sr-1)
Wheel mouse & VBE (2000, SR-1)
Toolbar button (Office 97)
Cell Protection (Excel 2000/Win98SE)
Excel Graphing (2000)
Add Special Conditions in a COLUMN (Excel 2000)
pivot table for multiple worksheets (2000 (9.0.2720))
Fourier Transform (2000)
Special formatting for output ('97/SR1)
Pivot Table Update in VBA (Excel 97/00)
Resizing a userform as large as possible (97 SR-2)
Using Find and also receiving row location (Excel97 SR1)
Trapping colorindex value of CFormatted cell (2000)
Link update on opening (Excel 97)
Reformatting Text List into Columns (Excel 97)
Combine 2 codes?(URGENT) (xls 97)
Copy/paste macros (2000 sr-1)
Countif ?? (Excel 97)
Shortcut Problems (Excel 2000 SR-1)
Conditional formatting & VBA (Excel 2000 SR1/ Win 95)
VBA Protection of Books ?? (Excel 95)
Excel prompt (97)
Progress Window (2000)
Sum nonadjacent numbers (Excel 2000 SR 1)
Add new name to list box??? (xls 97)
Vlookup Thesis Project (97 & Up)
VB code (xls 97)
Adding up only positives (2000)
Animated Pie Charts (Office 2000 SR-2)
MS Map and Excel 2002 (Excel 2002 10.2614.2625)
recreate WB w/o external links (xl97/xl2000)
Updating Links to worksheets that have tabs (Microsoft Office 98)
Accessing graphs created by the graph wizard (Excel 97 SR-1)
last 6 averaged (Excel)
tracking changes (Excel 97 SR2)
Saving array values (2000 Sr-1)
Sort/Count the number of occurances in a worksheet (97 or 2000)
Font resizes when printing multiple copies (2000 SR1a)
show numbers as thousands only (Excel 97/SR2)
Excel Solver error (office 97)
future value comparison (win2000)
Cell References & External Links (Excel 97 for Windows)
Find next blank cell in column (2000)
can't ZIP workbook (xl97/xl2000)
Converting text string to date format (Excel 2000)
E-mail workbook with custom toolbar (Excel 2000 SR-1)
how does Excel initialize itself (xl97/x.2000)
closing a workbook (2000/sr-1)
Default location for files didn't change (2000)
Highlight Row & Colum upon cell Select (2000)
Pause for User Input during Macro (2000)
Trace values to different sheet (Excel 2000)
Unable to double-click open Excel file (2000 SP1)
No. of days between two dates (2000/any)
validation list on another spreadsheet (2000)
Formatting on unlocked cells in protected sheet (Excel 97/SR2)
Rounding-calculations (2000 (9.0.2720))
Change in Data Source Location (Excel 97)
Traversing Sheets in a Book (2000)
ODBC problem (Excel 97 & Access 97)
Help with IF formula (Excel 97 SR2)
"Validating" a UserForm (2000)
running a form on various versions (200/97)
Second Y-Axis label (97 SR2)
expand cell to take all text (W98, O2k SR-1)
Deleting rows of check boxes (Excel 97, SR2)
custom page lengths (excel & word 97)
Offset time by -4 hours (Excel 2000/SR-1)
User must supply password before close excel... (Excel 97)
how do i check 2 sets of data? (Excel 2000)
sorting grades and marks...please help me.. (excel 97)
Displaying Strings (2000)
Open/close xls from Access (office 97)
seting focus (any)
Bullets/Numbering (Word2000 SR1 Win NT 4.0 (patch 6))
Sheet Based Range Names (Excel 2000)
Msgbox "No Return or Halt Function... (Excel 97 (SR-2))
List and auto complete (office 97)
ToolBar customizations won't stay (Excel 2000)
Moving down a Column.. (2000)
Deleting Links (2000 SR-1a)
fixing userform position (Any)
Copy/Paste/Clipboard (Excel 97, sr2)
blank records (any)
Spreadsheet appearance changing on opening (Excel 97 SR2)
Using a variable as Array() Argument (2000)
Auto correct Name Format Entered (xls 97)
Combine 2 text cells into 1 (xls 97)
combobox rowsource (any)
Macros (Excel 2000)
File Conversion from XL to ACCESS (Office97 SR2)
Workbook Protection (97 SR2)
Array formula which includes (1-n%) (XL97 Sr2h)
Color the Bars - II (2000)
Automatic chart ranges (2000 SR1)
Excel 97 (SR2)
Comments (Excel 2000 )
Feet and Inches (Excel 2000 SR1)
Time in Formulas (Excel 2000 SR-1)
formatting labels (any)
VB Code with charcter not numbers (xls 97)
Something of a reverse VLOOKUP (97)
printing worksheets (2000)
Updating Linked Information (Excel 97)
How to speed up a macro (excel 97)
Page Setup problem in Excel 97 (SR-2(i))
Importing Data (Excel97)
Autocolor & Update REPOST (xls 97)
Custom Time Function (MS XL97-2002)
Custom menu puzzle (XL2000 SR1)
Chart defaults (XL2000 SR1)
creating a formula using even or odd numbers only (excel 97)
Formula across several sheets (Excel 97 SR2)
Using Excel to retrieve and update SQL data (97,SR2)
Posting Spreadsheets to message board (2000/9.0.2720)
Array Formulas and Dynamic Named Range (Excel 97)
Save File as Diff. Name Each Time (2000/VBA)
Autocolor a cell (xls 97)
Hiding empty rows before printing.. (Excel97)
sheet protection (Excel 97 sr-2)
User Input inside a macro (2000 SR1)
Excel as web page (xl97/xl2000)
Prompt to update worksheets (excel 97)
Right-Click Conditional Formatting (97 / 2000)
Excel (97)
Validation Issue (excel 97)
Selection.Resize(2, Selection.Columns.Count).Selec (Excel 2000 SR1)
Xl startup (XL97)
Excel's Automatic color setting (Office 97)
Display date on useform... (excel97)
Color the Bars (Excel 2000)
Combo box/macros not working through IE (2000 SR1 & 97 SR2)
Blank from referenced cell came in as zero (Excel 97)
Date manipulation (2000)
CAN I USE VBA TO CONNECT TO MSQUERY AND RUN A VIEW (OFFICE97/SR2)
Vlookup (Excel 2000)
VBA CODING PROTECTION (EXCEL97)
Date Format in Header/Footer (2000 SR-1a)
Excel 2000 Header and Footer (Excel 2000)
Summarizing data (2000, SR-1)
Help With A Formula (Excel 97, SR 2)
Cell Referencing (xls 97)
Quick Reference Guide (97 SR2)
embedding graphic in header (2000)
Using text to create functions (Excel 2000)
Sort on Protected Sheet (Excel 97 SR1)
Data Range Stumper??? (excel 97)
is it protected ? (excel 97)
Grouping of Data into Formated report (excel 2000)
Distribute an Add-in that also requires a DLL (97 / 2000)
Filtering Dates (Excel 97)
VLOOKUP (2000)
Save with Visual Basic (97)
Auto answer Do you want to update links? (Excel 2000)
Deleting the first 4 rows of a range using a macro (Excel 2000 SR1)
Scenarios - auto (vba?) (Excel97SR2)
COPY FORMULA .END(xlDOWN) (EXCEL 97)
Do you want to save changes? (2000/2002)
Perhaps a "mask" (XL2000 9.0.3821 SR-1)
Data Validation, Again (XL2000 9.0.3821 SR-1)
Revisitng Data Validation (XL2000 9.0.3821 SR-1)
Send activesheet as attachment (2000)
Sort DATA into groups and Formated it in EXCEL (1)
How to determine if a comment already exists? (Excel 97 SR-2)
Copying data that contains formulas and paste it a (excel 97)
Dates (97 SR-2(1))
Capture Worksheet Delete Event? (Excel 97)
Conditional Formatting (Excel, Office 2000)
comments on charts (2000)
closing excel (2000)
Ideas Welcome (Excel 97, SR2)
Rounding to the nearest Quarter hour (97/SR2)
CALCULATE YTD (EXCEL 97)
Autosave and file size (Excel 97/2000)
Combination of cells to give a value (2000/any)
Finding Duplicates (Excel 2000 SR-1)
Percentages (Excel 2000)
Active Cell Color (2000)
Saving as csv (2000)
How to move to non-default cell after data entry (Excel 2000 SR1)
Insert worksheet clears clipboard (XL2000 SR1)
Looking For A Good Book (97)
need template wizard w/ data tracking help (Excel 97 SR 2)
Pivot table - counting instances (Excel 2000 SR-1)
"can't clear clipboard" (XL2000 (no SR!!))
minutes and seconds (office 97 SR1)
Cylce through buttons ((97))
How to print all cells as a list (2000/any)
Auto save Tables and Charts (EXCEL97/SR2)
Borders disappear (2000 SR-1)
File Format not Valid (97/2000)
run time error (97 and 2000)
Mk Color equal to serial number (Excel 97 SR2)
Automation Error (2000 SR1)
Making an XL table a database that can be queried (XL97/SR2)
Days in Month (97)
Copy subtotal values question (Excel 97)
Excel Pivot Tables Data Source (Excel 2000 SR1)-MULTI-Excel Pivot Tables D
Annoying Macro Msg. (Excel 2000)
Modifying Row Data in a Range (Excel 97/SR2/VBA)
Find Replace (Excel97 SR1)
Determine the HIGH Value (Excel 2000)
AVERAGE (2000)
Bug, Maybe? (XL2000 9.0.3821 SR-1)
"document not saved" (xl 97 (win NT machine))
Transpose (2000)
Help. I got a Pivot Table problem. (EXCEL97/SR2)
Auto date worksheets (Office 2000)
Strange Behavior When Copying Down a Column (EXCEL97/SR2)
importing a union query from Access (Excel 2000 (SR-1a))
Deleting rows from a range (Excel 97/SR2)
Msgbox doesn't work (Excel 2000 VBA)
Importing Numbers from a UPS program (Excel 97 on Windows NT)
Frequency chart (Excel XP)
Pivot Table sorting (excel 97)
Custom Color Palettes (Excel 97)
Non moving pagebreak (XL 2000)
Dynamic Ranges (2000 SR1 )
Sheet name in a cell (2000 SR-1)
Finding Last Row with data (Excel 97/SR2)
sorting text with "the" and "a" ignored (2000)
Saving as .PRN (2K)
Array Position (XL97; SR-2)
Force 4 digit year (sr1)
How to solved or avoid ghost links...inside.. (excel97)
Caomparing two databases (XL2000SR1)
Data Validation (Pick from list) (2000 SR1)
Macro for charts with dif ranges (2000)
Macro Code for Directory Selection (97 SR2)
Reference Outlook Custom Form field in Excel Fn (Excel 97/Outlook 97)
Pivot table sorting (Excel 97)
VBA Project Properties (2000/SR-2)
Locate chart data for a selected point (xl2K sr9)
new menu item subgroup (Excel 97/SR2)
Changing the Active Printer (Excel 97/SR2)
LOOKUP Problem (2000 9.0.2720)
Conversion from Lotus (Excel 2000)
White Dash Lines (Excel 2000)
Move new worksheet to far right (Excel 97/SR2)
Array argument with .WorksheetFunction (Excel 2000, SR1)
excel is read only (excel97)
I want a cell to only allow a specific text string (Excel 97)
sorting question (MS Excel2000)
Sorting row by value (Excel 97)
Add a worksheet (Excel 97/SR 2)
Formating column (O2k W98 Se)
variable data source (Excel 97)
Excel Template - dynamic chart (Excel xp)
Ejecting Zip Disk Crashes Excel (97)
Class detector (97)
Inserting a new row (Excel 97)
Average (2000 SR1)
Using Variable in Worksheets (2000 SR1)
Regression (2000)
Pivoting Data (Excel 2000)
Question about Rank Formula (Excel 97)
Sorting Cosolidation Code (2000 SR1)
Query another Excel File (Excel 97 SR2)
Counting consecutive non-zero values in an array (Excel 2000 SR-1a)
conditional formating (Excel 97)
Identify sheets with links (97/2000)
Ramdon Numbers and Information (97 SR-2)
extrapolate a data series (2000 SR1)
Different custom views on every sheets ===> (EXCEL97)
Hide all toolbar and some sheets... (EXCEL97)
Differences between Excel 97 and 2000 (97/2000)
Pie Charts (Excel '97)
Highlight plot area range? (Excel 97)
Option Buttons revisited (97)
Range name using offset (excel 97)
XL 2000 (XL2000 SR1)
Statistical Question (2000 SR1)
Macro with input box to choose range of dates (Excel 2000)
Years & Months between dates (2000-sr1)
Excel 2000 Colour chart prints in black and white (2000)
Linking Formats as well as data between sheets (2000)
Pie Graph Dispaly Labels (all)
Working with WinZip (Excel/VBA 97>)
How do I have a fn write a blank cell (not a null) (Excel 97)
Excel Query (2K)
True being changed to TRUE centre aligned (Excel 97/SR2)
PageBreaks (v97)
Format cell contents depending on value of functio (2000)
HLOOKUP (2000SBE)
unlock protected project (xl97/xl2000)
How to make a toolbar button for find&replace (2000)
Programmatically detecting grouped sheets (2000, SR-1)
Making an code in an Event available everywhere (Excel 97 SR2)
Fail Result Detector... (Excel97)
Need help with index match functions...inside.. (EXCEL 97)
Application.OnTime (97sr2)
changing cell contents from access (Excel 97/SR2)
Save Active Worksheet as it's own work book (97 SR2)
Consolidating Data (2000SBE)
Problem with sorting data on a protected sheet..in (Excel97)
List Select in XL 97 (Excel 97)
Quotation in VBA (Excel 2000 SR-1)
extend mode F8 (Excel 97)
Show file path on footer (2000)
Close without saving (Excel 97/SR2)
Update on wkb bloat & 2 requests to enable macros (Excel 97 SR-2)
Custom Toolbar blues in Excel 2000 SR1 (9.0.3821 SR-1)
actions before workbook_open (xl97 / 2000)
Sharing Macros (Excel 97)
Problem opening a 97 file in Excel 2000 (Excel 2000)
Implement expiration policy (Excel97/2000)
Create Directory in VBA (97 SR2)
Workbook_BeforeClose and DisplayAlerts (XL97 SR2h)
If stmt e-mail (Excel 97)
Unable to Print (2000)
Stacked Bar Chart (Excel 97)
Subtotals/related records (Excell 2000/SR-1)
Basic VBA (Excel 2000)
Excel Patches (Excel 97)
Option Buttons (97 /Not sure)
Worksheet CodeName Property (Excel 97)
Header and footer colour (97 SR2)
Print to File (Excel 97)
Concatenation and Lookups (Excel 2000)
Test format from All Caps to initial caps (O2k SR-1)
xlquery.xla and Excel97 (Excel 97 SR-2)
Data replication on multiple worksheets (Excel 97)
Width of name box (Excel 2000)
Print Embedded Charts (EXCEL97 SR2)
Print preview,scaling, hardcopy don't agree (Excel 2000)
Fourier Analysis tool (97/SR2)
Excel (2k)
Headers (2000)
Ctrl+End Behaviour (Excel 97 SR2)
Year-to-date (Excell 2000 SR-1)
Excel Auto Save add-in (XP)
How 2 know which cells reference a particular cell
MouseMove Event (97 SR2)
can't save file (xl2000 on W2k SR1)
Mail Merge (Microsoft 97 Excel )
Default Save Directory in Excel 97 (Office 97 SR2)
Combo Boxes: Limit to List (97 SR2)
Application Window States (97 SR2)
Excel Toolbar file (Excel97SE)
launching more than one excel application
Formatting Survey (97,2000)
OT: JavaScript Lists (Any)
Data Validation: Userforms & Combo Boxes (97 SR2)
GETPIVOTDATA (Excel 97)
Text Linked to Series Point (2000 SR1)
VBA-EMail Syntax (97 SR2)
Arrays (97)
Convert Lotus with .123 extension (Lotus 9 to Excel 2000)
All decimal formats display "N" instead of decimal (97 SR-2)
Email ? (Excel 2000)
Filename appended with 1 (Excel 2000)
Running out of memory with Hidden (97 SP2)
Print dialog (XP)
Counting Non-Zero Values (with a twist!) (Excel 2000 S
Matryx Users to share experience (97/00)
Excel not a valid Win32 Application (97/sr2)
Manager Name In Header (Excel 2000 / SR-1)
Negative Numbers in Brackets (Excel 2000 SP2)
Two Versions as Once (Excel 2000)
recover lost Excel workbook (Office pro 97 )
Array Formula (2000)
Built-In Functions (Excel 2000)
Linking Data in different Workbooks (Excell 2000/SR-1)
Problem editing e-mail list (Excel 2000 )
Delete Rows Equalling Zero (Excel 97 SR2)
Out of memory - External Data (XL97/SR-2)
Fatal Exception OE 0028:CC49AE3A (Office 97 SR2)
Excel Protection (2000 SR1)
Date comes out as formula!! (Office 2000)
User selection for pivot table (excel 97)
moving formula (Excel 97)
Summing a range of Values (Access 2000)
Out of memory ? (SR1a)
Excel not launching from file (Excel 0.0.4402 SR-1)
Data Form problem
Formatting Text in Combo Boxes
Excel 2000 Custom Format
Determine Value
Counting Data
Conditional Formating
Auto updates
AutoFilter
Excel 97 Default Workbook Template
File growing by megs at a time?
Find Linked Cells
VLOOKUP (a new question)
Print titles
Finding largest value
Extendable data sheets
Pivot Table
Insert file name into a cell
Write number in letter form
clustered stacked chart
IF function using dates
Chart appearing/disappearing
Placing Worksheet Names into cells
Chubby spreadsheet
"IF" conditional question
Ignore Remote Requests
Calculating time
Adding alternating fields
Recently Used
Print Excel doc
Copy/paste to filtered list
Date span
Named Range Changes Each Time I Run Macro
Advice Please!
Excel Add-Ins
MSQuery - how to compare fields
Conversion
XL97 SR2 - Cell reference formatting problem
XL97 - Checkbox reference in code?
Statistical Reporting: Data
Does Not Update
Range selection
Data Validation
Chart Window
AutoAvg
Specifying Angles
Excel Task Pane Disappears
Cleaning Up Named Ranges
Plot empty cells doesn't work
Basic Excel Tutorial
Can I Show Values AND Labels on a Pie Chart??
Custom Rounding
How Can I Select a Dynamic Range
Hide Macros Excel 95
Excel 95 Dialog Sheets
Popup MsgBox When Workbook Opens
Numbers displayed as exponents
Save a range
Copy/Paste from VBA