Windows Secrets
Windows Secrets Lounge
days between dates (2000)
Hours Calculation Function (Excel 2002)
passwords (2002)
Cells Not Updating (97:SR2)
calculate weekdays between two dates (MS Excel 2000)
Replacing name reference in formulas (2002)
charting on two axes (XL 97 sr2b on Win2K/NT4)
textbox as value, not text (2002)
Web Query (Office XP)
Pivot Table (2000)
% chg from neg to positive not working (Excel 2000)
Aggregating Coursework Marks (2K/XP)
Counting Visible Sheets (97; SR2)
Adding Time (XP professional)
Cut Row and Paste as Column (Excel 2000 or XP)
Sort worksheets alphabetically (XP)
Combinations (Excel 2K/XP)
=PMT, but backwards (97 sr2b)
Validate lookup table (XP)
Linked Objects (2000)
criteria (97/2000)
Landscape over network? (Excel '97 SR-2)
Autofilters using top 10 percent (Excel 2002)
Conditional Formatting (Excel 97)
Functions/VBA (XL2000/VBA)
Extremely Large Excel Files (Office 2000)
Table to List (XP)
Finding the rate and Graph Question (Excel 2002)
Finding vlookup with dates (Excel 2000)
Number of week in month (Excel xp)
Using class in add in (2002 sp-2)
SumIF (XP)
Personal.xls (2000)
Populating a spreadsheet (XL97/WinNT4)
Format Numbers (97)
Green Error Indicators (Excel2002)
cell content challenge (Excel 2000)
Lock Cells or Row in macro (Excel 2000)
Time (2000)
Unique Entries (Excel '97)
change macro address to relative (XP)
Control File|New dialog (2000/SR1)
Call To VBA in Another File (97:SR2)
Word to Excel (ExcelXP)
OL Not Registered error (OXP-SP2; WinME)
printing out code in colour (XL97sr2 on Win2K/NT4)
Pivot Tables (Excel 2000)
Questions on pivtbl calc fields/items (XP)
Auto Numbering (Excel 2000)
Pie Chart with Value & Percent (Excel 2000)
Workspace function (Excel 2000)
Seagate Annoyance! (Excel 2000)
Starting toolbars (Excel 2000)
Email Merge (XP)
Wrapping merged cells (Excel 2002)
Application Quit (Excel 2000)
Wrapping text (Excel 2002)
Minimum Values (2000)
Help! Help!
Days Of Month (2000)
SpreadSheet Explorer (2002)
Calling a Logo from an Equation (2002)
Automatically Update Footer (2000)
Multi select list box (XP)
removing custom entry from a context menu (XL97 sr
Removing a hidden module (2000)
Excel Takes Forever to Launch (2000)
Dynamic Print Range (Excel 2002 - XP SP2)
Macro help Excel 2000 (Excel 2000)
IF function (XP)
Extract and mail section of worksheet (2000)
Sorting on relative references (XL97/WinNT4)
Checking Capitalization (Excel 2000)
Prevent Formula Changes (Excel 97)
Down selecting data through multiple columns (Excel 2002)
Excel lookup (Excel xp)
'Book.xls' Already Open ?? (Excel 2000)
Sum every other column (Excel 2000)
Hyperlink in Protected Sheet (Outlook 2000)
Opening Excel File (Excel XP)
Multiple Workbooks (MS Excel 2002/Win XP)
Drop .00 but not .03 (Excel XP)
Save CSV as Unicode UTF-8 (2000 SR-3)
Obtain window 2000 userid (not username) (XP)
Linking Cells Between 2 Workbooks (Excel 2000)
Can't open file (2002)
List Data Validation (Excel 2000 SR-1)
Template Wizard won't save (2000)
Add-in Function - how to find it (Excel 2000)
sumif Function (Office 2002 SP2)
Record Counts (2000/XP)
File path in Footer (Office2000)
Nested Grouping (2000 SP3)
Mystery box is driving me crazy! Please help ... (Excel 2000)
Summing of music running times (2002 SP2)
Help with Spreadsheet formulas (2002)
Spell Check a Single Word with VBA (Excel 2000 SR-1)
Indirect validation list range (Excel2000)
Watermarks (Excel 2000 and XP)
macro help Plz... (XP)
Nested If Thens (1)
Synchronizing Pivot Table Page Fields (Excel 2000)
Bars don't line up (excel 2002)
watermarks in Excel? (Office 2000)
Dates (97:SR2)
Now() (2000)
SUMIF (97:SR2)
Open Specific WorkSheet in Excel (Off XP Pro)
Showing Smiley Faces depending on condition (2000)
Percentage Formula (MS OFFICE 2000 PRO)
Enable/diable macro (2000 SR1)
Buttons On Worksheet (XP)
MATCH Function (OXP-SP2; WinME)
ExcelXP Shortcut Key to Formula Bar? (XP SP-2)
Excel XP Shortcut Keys? (XP SP-2)
Allocation criteria (Excel 97)
Converting cell to number (XP sp2)
runtime error (office 2000)
Relating Top,Left, height, and Width (Excel 97 and >)
Workbook Navigation (XP)
Scenario Manager (2000)
NameTages (Excel 2002)
Advanced Filter - Best practice (97:SR2)
Remove chart margin space (Excel 2002)
Old macros (2000)
Filter on cell color (XP)
Preventing A Blank Cell (Excel 2K/SR1)
if function question ('97, SR-2)
Cells Flagged Not To Print (97:SR2)
Splitting Data in Cells (XP )
Loading an Addin via Registry (Excel 2000 SP-3)
Auto Coloring in Excel (2000 Professional)
consolidating several worksheets (Excel 2000)
Tab Names (Excel 2000)
Insert Comments (Excel 97 & Excel Mac X)
Modify Graph Debug (2002)
ShowDependents (97 SR-2)
Email authentication (XL97/WinNT4)
Is it possible to set variable cell validation? (XP)
Getting a macro to understand option buttons (excel)
conditional formatting of text (2000)
retaining trailing zeros (XL 97 sr2 on Win 2000/NT
Chart macro (2002)
Wrong Century Displayed (XP)
Installed & won't work (2000)
use next row? (97, 2000)
Drop Down Boxes on Cell (Excel 2000)
Opening a file (Excel 2002)
Checking Data on part of a cell (Excel 2000)
Saving format changes to .csv file (2000 SR-1)
IFODD statement help (Office XP)
finding old advice (excel 2000)
Auto Run options (Office 2000 Pro)
IF function? (Office XP)
stop the flashing (office 2000)
Slow Excel 97 (97)
Emailing with Outlook 2002 (Excel 2002)
Excel 2000 hyperlinks (2000)
Runtime error (office 2000)
Can't Remove Gridlines - Causing Anxiety :-) (Excel 2000)
MSN Money Stock Quotes (Excel 2000)
Hiding Sheet (97:SR2)
So what's numeric? (2000)
Name Conflict pain (excel 2000)
Reverse Pivot Table ? (XP SP 2 )
How do you check a range is empty (97sr2)
.csv files (excel2000)
Saving worksheets to separate files (Excel 97)
Recent File List Not Working (Excel 2000 SR-1)
Multiple Passwords (XP)
Close Workbook with VB (2000)
Availability of Excel 2002 Post SP2 Hotfix Package
date query (Excel XP)
Minimised Userforms (xl 97)
Rename sheet grayed out (Excel 2000)
Error Type Formula (Excel 97)
Auto Fill Not working (XP )
Save a file (2000)
Template Wizard not working (Excel 2000)
Handling Lengthy Text in Excel?? (Excel 2000)
E-Mail Worksheet Only (XP)
Test Ranges (XP)
Custom Toolbar/Excel Add-in (Excel 2002/SP2)
Formula (Excel 2000/SP3)
Counting records? (Office XP)
Using Proper and Lower functions (Excel)
Concatenate (2000)
counting with dates (2000)
File Path in Footer (97:SR2)
Finding duplicates (2000)
Returning a column letter (2000)
Drop Down List (MS OFFICE PRO 2000)
Cell Formatting (97:SR2)
selecting the current row (XL 97 sr2 on Win 2K)
Forcing cell entry (2000 / SP3)
Calculation (Excel XP)
Error on inserting rows (2000)
Opening Attachment (Excel 2002)
VB System Error (XL2002)
Create Subset Files (2002)
Averaging between ranges (SR97)
Headers (Excel 2k)
Automation: delete columns is failing (97)
Weighted moving averages formula (2k/SR 1)
Moving last names to another column (Excel 2000 SR1)
Colorizing Sheet Tab? (Excel 2KPro, O2KPro, Win2KPro)
File | Close on a workbook (Excel 2KPro, O2KPro, Win2KPro)
Tools\Macros\Security menu not available! (2000 SR1a)
Error opening file in XP (2002)
Reverse Lookup (2000)
Is there a better way to do this? (Excel 2002)
Matching values in a workbook (Excel 2000)
Paste link in VBA (2000)
Fuzzy search/ regexp (2000)
Memory Problem in Excel 200 (Excel 200)
Application.Caller (XP & VBA)
Deleting Rows (97:SR2)
Printing worksheets in a Workbook (Excel 97/SR2)
last column with text copy to next column (2000)
Help ! Emergency ! (Excel 2000)
Moving modules vs moving sheet tabs (Excel 2000)
Grid (Excel 97 SR-2 (1))
Sending Same Sheets to Several Email Recipients (Excel 2000)
Sort by format (97 SR-2 (h))
Multi-colour data points in scatter chart (97)
Security (MSOFFICE 2000)
Can't open Excel 97 file (MS Office 2000 Pro/SP-3)
Functions (MSOFFICE 2000)
Paste v paste special (2000)
gridlines covered up by fill color (2000 SR1)
XL App Error (97:SR2)
psycho Excel selecting problem (2K)
Drop down list (2002)
Excel extract from LDAP source (XL2000)
A couple of questions (maybe easy!) (Excel 2KPro, O2KPro, Win2KPro)
Pivot Table Controls bypassing Worksheet_Change? (2000)
Inserting numbers from word (xPRO)
cut/move multiple cells (Excel 2000)
IsBlank Function in VB (XL(97))
Track Changes turns off. (Excel 2K -sr1)
on screen view truncates my cells text
Avoiding duplicate edits (Excel 2000)
Copy Borders (XL2000)
Mass rename of macro buttons (2000 SP1a)
Interactive Links in Excel (Excel 2000)
Moving text (2000)
Combobox problems (2000)
Breaking a link (2000)
Why This Macro Only Work On One Sheet ? (Excel 2000)
Automatically filling a column (XP)
Common Dialog Control (2000/XP)
Delink Chart with Data (Excel 2000)
Compression (2000 SP-3)
Word Excel paste link (2000 SP3)
97 to 02 (02)
Custom Message - Protected Sheet (2000)
External Links (97:SR2)
Calculating Formulas (Excel 2000)
Excel Header from cell formula (2002)
workspace copying (xp)
linking workbooks (XP)
VisualBasic Macro to Indent (Off 2002/XP Pro SP1)
Filter by cell color? (XP)
What is up with these drop down buttons? (office 2k)
Decimal test (2000)
Where is the Macro? (office 2000)
Combining bar and stacked bars in a chart (Excel 2000)
Linking to worksheets (2002/SP-1)
Created Menus (XP)
Changing Dates to Text (Excel 2000)
Comment box size (Office 2000)
Updating Records (2000)
Dropdown list in cell (2000)
Offset() in Graph (XL2K)
Max / Min with error cells (Excel 2000)
Dynamic Cell Entry (2002 XP)
MS Query Trouble (2000)
Conditional Minimum (EXCEL 2000)
Sorting (2000)
Pivot Table Page Fields (Excel 2000)
Pivot Table Columns (Excel 2000)
'Ne#' USB Printer Port Settings (XP Home)
Spliting A List To Several on Different Sheets (Excel 2000)
Excel- Page Numbering (XP)
Calculated Fields and Pivots (Excel 2000)
Email Different Sheets to Different People (Excel 2000)
Column and Row Headings (XP)
conditional vlookup? (97 SR2 (h))
MultiPage Control (XP)
Excel files saving as Word document (Excel 2000)
annual average growth (Excel 97 or 2000)
CAN'T OPEN EXCEL (xl2000 sp1)
VBA function (XL2000)
Password Cracker (2000 SR-1)
Excel and XML (2000)
Cell Aliases (2000)
Saving Toolbars Etc. (Excel 2000 - XP Home)
Error report (Excel 2000)
airline airwaybill sequences (97)
Excel (All)
Restoring Settings in Excel (Excel 2000)
Match limited # characters in cell not exact (Excel 97)
Damaged .XLS spreadsheet (9.0/2000)
Worksheet (not Workbook) change detection (Excel 2000)
Cell function problem (Excel 2000 SR-1)
Link Excel Data to MS Project (Excel/Project 2000)
Format to CAPS (XP )
Convert Time (Office XP)
Creating a Desktop Shortcut (xl2000)
Counting data (Excel 97 SR 1)
Max Values In Columns (2002)
Generating Table of Contents (Excel XP)
Personal.xls not running at Excel startup (10.4302.4219 SP2)
XL Hangs on Close (XL97:SR2)
Printing Dynamic Range (Excel 2000)
Help on IF statements and nested IF statements (Excel97)
words instead of cell numbers in formulas (2000)
linking data between excel documents (excel 2000)
exporting (2000)
Complicated IF Statement (XP)
How do I prevent a template from being overwritten (2000)
Trendline with polynomial fit (2000)
Stripping characters (XP)
Comparing data in columns (2000 sr-1)
Memory errors (Excel 97/SR2)
save and overwrite (2000)
Partial formatting of function results (XL97 sr2, WIN2K)
Chart (2002)
Permission denied (Error 70) (Excel 2K and >)
Option Setting (Excel XP)
Creating and Rotating an Object (97 or Higher)
Find/Replace errors (xl2000/xl2002)
Change $ to other currencies in entire model? (XP)
Control Toolbox Button (XL97;SR2)
Menu/Toolbar Actions (Excel XP)
Perosnal Macro does not work (Excel 2000)
Worksheet format question (Excel 2000)
Links to Other Workbook (Excel 2000)
Run Desktop Shortcut (XL97;SR2)
What happens if find fails (2000)
Count Rows (XP)
Accessing Calendars (EXCEL2000)
Formula for sequential years (any)
Disabling macros (xl2000)
Proportionate circles (Excel xp)
Prompt to save non-existent changes (Excel97 SR2)
Automatic sequential row numbering (Excel 2000)
Deselect single sheet (Excel XP)
Preventing Save AS (xl2000)
Text is not wrapping correctly (v 2000 (9.0.4402 SR1))
Converting upper case text (Excel 2000)
Validation Text Box Location (EXCEL2000)
Dialog Box Controls (XL97:SR2)
Automatically fill in current date? (Excel 2000)
'Problems obtaining data' error in pivtbl (XP (SP2))
Button with result in messagebox (Excel XP)
Tracking number of employees (office 2000)
Interpret this message (Excel 2000)
cell must contain numerics (97)
Pasted Column Won't Sum (2002 SP2)
Excel Object on top of Excel Sheet ? (Excel 2000)
inserting alternate blank lines (excel 2000)
Getting data from a website (2000)
macro for every Excel File (Excel 2000)
Delete 1st byte of text if it meets criteria (Excel 97)
Available Printers (XL97; SR2)
Export a Named Range from Excel to Access... (2000 SR-1)
Some kind of count fxn - I think . . . (Excel 2000)
Row function plus a number? (Excel XP)
Custom Header question (XP)
Prevent printing of single worksheet (Excel XP)
Fill a series using the pattern of another series (2000)
Excel templates (XL 2000)
selecting a filtered cell (Excel2000)
Pocket Excel (Excel)
Personal.xls (Excel 2000 SR-1)
highlighting changes after pivot refresh (excel 2k)
Conditional Format on Font Color (Excel 2000)
'SUMPRODUCT' with 'IF' (Excel 2000)
Help importing Word text/file into Excel (97/SR2)
How to refer to another cell (Excel 2000)
nested ' IF ' more than 7x (officexp 2002)
Macro/Paste Record Excel to Access (97)
Save As in a macro (XP)
Email one Sheet of a WorkBook (Excel 2000)
Hiding Rows with zero sum, with conditions (9.03821 SR-1)
Sendmail questions (XP)
Insert cells with previous formulas? (Excel 2000 )
Cell Formatting (97)
Unhide Column A (file imported from Lotus) (Excel 97)
Open at Specific Sheet (Excel 2002 SP2)
Find and replace (Excel 2000)
Column Fill (2000)
Share Toolbars with other User (2000)
Indirect Fn; Combo Boxes and Input Ranges (2000/SR-1)
Blank Lines (2000)
Hyperlinks (2002-SP2)
count items in a sentence (2002)
Print Excel Duplex Odd & Even? (XP SP2)
Setting Print Area (Xl 97)
Home Function (OfficeXP)
Adding text box/labels to a chart (Excel 2000)
Set a Default Date Format Followup (2000 SR-1)
Mailto string for workbook attachment (xl2000)
Path to AddIn not Saved (Excel 2000)
Sumif With 2 Conditions (2000)
UserForm | Control Tip Text (XL 2002)
Reversomg Names (Excel 2000)
Large Amount of Text (Excel 97 and >)
Formatting cells as hours, not time in excel (2000)
Form Textbox Control (XL97; SR2)
Excel help (xp)
Deleting empty modules (2000 SR-1)
Chart Formatting (XP)
Link Finder (2000)
Hyperlinks not relative? (EXCEL 97/2000)
Sumif (Excel 97)
Feet and Inches (XP)
Scale while creating chart (Excel 2000)
Document not saved (Excel 2000 SR1)
Code for Looping thru Ranges (2000 )
SUMIF COUNTIF(2000/2002)
Chart Wizard IPF in MSO97.DLL (97)
Blank Rows (2000)
Macro Options Error (2002)
Comment Box size (Office 2000)
how to have a formula build a table! (version 2000)
UK data fro Microsoft Map for Excel (2K/SR1)
SetFocus Trouble??? (Excel 2000)
Explanation of QUARTILE calculation (XP)
how do I delete duplicate rows (97)
Data Validation-Dynamic List (Excel 97-SR2)
Lacking any brain power!!! (Excel 97 and >)
Finding next blank row (xl2000)
Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)
Personal xls (2000 SR-1)
Excel Automatically Changing data in Cell (2000)
Turning Off Automatic Update Reminder (2000)
Help on cell comments (OXP)
Virus or Something Else? (Excel 97)
Date / Time calculation (2000)
delete rows between defined names (2000)
Cell comments (2000)
Chart Formatting (XP)
Storing user-defined functions in personal.xls (Excel 2000 /Windows XP)
2 Y-AXIS BAR CHARTS (Excel '97)
Paste link gives zero (Excel xp)
Prevent User Closing UserForm (XP/2k)
Events for Drop-down box Results (xl2000)
Times and Numbers (Excel 97) (267954) was moved to the VB / VBA board
Bookmarks in excel (Excel xp)
MS Query to Access Database Fails (Excel 97)
naming cells with a macro (excel 2002 sp-2)
Conditional Max (Excel 2002/XP)
Guass normal distribution curve (XL2000)
time Formatting (xp 2002)
Change 'Licensed to' string (EXCEL 97)
Shared Workbooks (XP)
Server-side Automation (2000/2002)
switching formula source data (Excel 97/2000/2002)
Any Excel/Word magizines (2000/sr2)
Excel Invoice project (2002)
Conditional Row formatting (Excel 2000 SR-1)
Preventing Excel from making email addresses links (2000)
Password protected workbook (XP)
Excel Charting (XP)
DataValidation (XL2000)
Circular Reference Toolbar (Excel 2000 SP2)
Excel error (97-SR2)
Increase a group of number by a specific amount (Excel 2000)
Losted Pivot Table Data (Excel 2002)
IF Function (Excel 2000 SR 1)
Sorta combining rows (Excel 2000 SR1)
Automatic Calculation (Excel 2000)
Using the checkbox (excel 2000)
inserting LastSavedDate/Time (Win 2000, Excel 2002 SP-2)
E-Mail Hyperlinks (EXCEL 2002)
Clearing COM addin cache (Excel 2002/sr2)
using the MIN command (excel 2000)
Excel (2002)
Referencing Sheets (2000)
SendMail Options (2k)
Large numbers in cells (Excel 2000)
Lose precision when copy between cells (2000/2002)
Pivot Tables (2002)
Can't remember Addin (XP sp-2)
Copying Cells (Excel 2000 SR1-a)
Force it to be text (2000)
Range Sum (2002 SP-2)
Number Formatting (97)
Times and Numbers (Excel 97)
Sicky Cells (XP SP2)
Delete a picture with vba (excel xp)
Time Expired Between Two Dates (97)
Huge Spreadsheet Size (Excel 2000)
MOS Certification (All)
Summing coumns of differing lengths (XL2002)
Multiple Conditions for COUNTIF Function (Excel 2000)
paste value parsing (Excel 2000)