Windows Secrets
Windows Secrets Lounge
Hyperlink to Word (Excel 2002)
Adding (Excel 2000)
Solomon III accounting package (Excel 2K SR1)
Chinese characters (EXCEL 97/2000)
Tab order (Excel 2000/2002)
Copy data to new spreadsheet (Excel 2002)
1,024 cell limit (Excel 97-2002)
last entered data accross 2 worksheets (2000)
More conditional formatting (the saga continues) (Excel 2000 SP3)
Shared WBook (97)
Find specific Worksheet - if exists (Office 97 and XP)
Font and Zoom (XP)
Update to name manager (97 2000 2002)
Editing a custom toolbar (Excel XP)
Formula giving Value# error (Excel xp)
conditional format--fonts (Excel 97)
Summary Page (2000)
stocks (2000)
Online Tutorial
Text String (Excel 97)
Need to print the exact freeze pane or hide column (excel 2000)
Saving part of workbook (2000 SR-1)
changing between nearest $ & nearest Thousand (Excel 97)
code to clear clipboard (excel 2000)
Web Queries (XP)
Deleting Links (Excel 97) (Excel 97)
Lock ups - have to minimise & restore to recover (2002 / WinXP)
Macro to add record and sort (Excel 97)
Deleting Multiple Columns Macro (Excel 2000)
Lookup Problem (Excel 2000) (9.0.4402 SR-1)
Median and Mode formulas (Excel XP)
Prevent modify of worksheet (Excel 2000 SR-1)
Compile Error in Hidden Module (XP/SP2 on W2k)
Maximum # of Variables (Excel 2000)
Remove Addin (2002)
Dates & Days (all)
Conditional formatting and dates (Excel 2000 SP 3)
cannot shift obects off sheet (Excel2000)
Additional Fonts (2002)
Sig Diff for proportions formula (Excel xp)
Cancel Button (XL97;SR2)
Bypassing the Delete Sheet Alert (2000 (9.0.4402 SR-1))
Selecting row on one sheet and filling in data on (Excel 2000)
Password on Save As Screen (Excel 2000)
Multi items and time (Excel 2K)
Cell Limit (XLS 97 and 2000)
Module Problem 2000 to 97 (Excel 97)
Finding cell <> 0 (2000 SR-1)
Filling a number series in Excel XP (Excel XP)
Referencing Cells (2000)
Excel 97 SR-2 (Excel 97 SR-2)
Trying to automatically update chart range (2000)
Secure Excel Model (2000)
Text To Number Conversion (2000 sr1 sp3)
Fill with Above (Excel 97 SR2)
Using 'AND' in Conditional Formatting (v97 SR2)
Conditional Formatting (2000/SR-1)
Empty String > 0??? (2000 (9.0.4402 SR-1))
Code problem (2000)
Searching for Excel Macro (97 to XP)
Records per min. (Excel 2k)
Protecting against cut & Paste (all)
Why doesn't this equation work (Excel 97)
Conditional Formatting (XP)
Lookup Function - Tips please? (Excel 97)
Sorting (2000)
Lesson 12 example in Excel 97 Step by Step VB book (97, 2000, 2002)
Dates on Graphs (xl97)
Pasting reports from PDF to Excel (Office 2000)
PivotTable Row Fields (Excel 2000 SR1 (v 9.0.3821))
Excel Dates (Excel 2000)
Text with leading 0 to a number (Excel 2000)
Deleting Styles (XL 97)
Finding Excel Macros in Excel 97 and 2000 (Excel 2000)
Converting Dates to Text (2002 SP-2)
Color condition on values in cells? (Excel 2000 SP-3)
Frequency/data set (2000/XP)
VBA on open? (2000)
Need help with the FILL feature (Excel 2002)
ListBox Performance (XL97: SR2)
Drop Down Boxex (Excell 2000 PRO)
ListBox Return (XL97: SR2)
Count Days (including start date) (Excel 2000)
Ampersand not printing (Excel 2002 (10.4302.4219) SP-2)
format text box (etc (972b, 2000)
Display multiple lines on one form (97 SR1)
Importing Data (2000)
Opinions wanted (Excel 2K and >)
Macro to display defined cell names(Excel 97 SR-2) (Excel 97 SR-2)
Conditional Formatting (97)
Eliminating #DIV/0 error from entire sheet (Excel 2000)
Changing Hyperlinked Picture Association (Any)
Maximum Value From Noncontiguous Cells (2000)
Comments Indicator (2000)
Private Workbook? (2002 / '97)
Name Manager update (97 2000 2002)
Should be simple (Excel 2000 SR 1)
Pausing macros (Office XP)
can't update automatic links (2000)
automatically trigger an email hyperlink (xp)
Naming Cells across mult. sheets. (W2K, O2K.)
Series order - Primary vs secondary axis data (2002 SP2)
How do i modify this code (Excel xp)
Inefficient macro (Excel xp)
Insert a character (Excel XP)
Excel - Create a scrollable text box (97)
Call a sub in an .xla from another file (Excel xp)
Excel macro needed (XP)
FIND formula returning error (Excel xp)
Copy Value Only and Paste (Excel 2000)
Duplicates (Excel 97/2000)
Formula into a cell (Excel 2000)
Print a Defined Set of Pages each time (XP SP2)
Opening Attachment (Excel XP)
Feet and Inches (WinME; OXP-SP2)
No changes - asks me to save changes (Win2000 Off 97)
Currency Transformation (XP)
Excel 2k rounding off issue... (Excel 2000)
HTML Paste (95+)
Vlookup to the left? (Excel 2000)
Accessing Addin methods (Excel 2000/SR1)
Sort Not working (Excel 97/2000)
Hiding cell contents (1)
Counting with multiple criteria (XL97/WinNT4)
thumbnail (2002)
Array Formulas in Lotus (2000)
Sort by High Lighted Cells (Excel 97 SR-2)
Macro Help (9)
Edit; Replace All (Windows 98; 2000)
A template or XLA version information (Excel 2000/SR1)
Select Method of Range Class Failed (2000)
Date to date in year/month format? (Excel 2000)
MS Query (XP)
Password Protecting Excel (2000 SP3)
AuotExec or AutoOpen (XP)
Graph question (EXCEL 97/2000)
Counting problem (XP)
Last Value in range (X2K)
Flawed formula, not sure (Excel xp)
regex---replace numbers (excel97+)
Conditional Format (XL97:SR2)
Mimic Time Mask (WIN2000-XL97)
change an addin's path (2000+)
RE: Clock and time difference (Windows XP SP2)
Automatic fit contents to cell size/column width (Excel 2000/SP3)
Add Word 2002 documents word to excel (Excel 2002)
Graphical what if's? (Excell 97)
Proper use of IF and OR (Excel xp)
Blinking cells (Excel 97)
Macros not running (Excel 2000)
Stopping a macro (XL97/WinNT4)
Conditional formatting for Div/0! (Office 2000)
Auto increment values (2000/XP)
Color Pallet (XL97:SR2)
Radio Buttons (2K SR-1)
Cannon Problem (200)
Find value NOT equal to 0 (Excel 2002/SP2)
Need Formula (using Lookup, maybe?) (Excel 97)
Excel Open/Close Error (Office 2000 )
Long formula needs help (excel xp)
Calculating Time (2002)
How to make user forms sizeable (Excel 2000)
Flexfind won't run - compile error (97 SR-1)
Macro to merge text (Any)
Display worksheet name (2000)
Shared Workbook Tips (2000)
Add jpg from Excel to ppt (office xp)
If Statements (Excel 97)
50 pages only prints the 1st page (excel 97)
Macro to format sheet (WIN2000-XL97)
See formulas (XP)
Duplicating Range Names (XL 97 SR-2)
Endless sheet activate loop (Excel 2000/sr1)
Flexible Find utility (97 2000 2002)
Excel Link to Access Code (2000)
using time calculations (xp)
Worksheet protection (XP)
Changing Default file locations (Excel 2k)
Formula only adds H cells w/ a cells that have 'b' (Excel xp)
Calculating in formulae (XL97/WinNT4)
Excel on the intranet (2000)
Blank data fields (2000)
Paste Chart as Picture in XL (XL97)
Useless Things you can do with Excel (2000)
unlock cell on condition (XP)
Page Setup Only Effects First Page (97)
IIF (2000)
Fixed Object Will Move (2000)
Create a 'Blank' Cell (2002)
Use of Scanner (Excel 2000/2002)
Pivot Table Auto Format (XP)
xllastcell and copying (Excel 2000)
Find & Replace (2K)
Title bar???? (Office XP)
Average (Excel 97 SR2)
Counting Dates Based on Other Cell Match (Excel 2000)
data validation list - not working! (excel 2000)
Changing a Chart's Scale (1)
COM Addin Designer (Excel 2000/sr1)
Currency Formatting (2000)
Cluster / Stack Charts (2000)
SUMPRODUCT As a replacement for Lookup formulas (2000)
AutoExec or AutoOpen (2000)
Conditional Summing (2002sp1)
Chart folders (2000/SP3)
sort, >3 criteria? (97, 2000)
Stripping excess html code (Excel 2002 SP-2)
Round up formula (Excel XP)
Merge cells in macro code (Excel xp)
Scroll Lock behaviour (Any)
Turn off URL (Office 2000/Win2000)
how do i print row 1 on all printed sheets (2002)
Long formula help (Excel xp)
Dynamic File Save as (EXCEL 97, Win 98)
getting macro to return a function in a given cell (excel 2000)
RunTime Error 1004 (EXCEL 97; Win 98)
Paste link, zero values (Excel xp)
Strange IF conditonal problem (Excel 2000/SR1)
Opening docs from a browser (WinNT/Word97) (239240) was moved to the Word board
Difficulty opening Excel (Excel97 SR2 on NT 4)
Passwords (Office 2002 SP2)
2 IF statements (excel xp)
Watermark Without WordArt (2002 XP)
Split the contents of a cell in Excel into three (Excel 2000 or 97)
Complex Counting Problem (Excel 2000)
Calculating Formulas from formulas (Excel 2000)
Two-color Cell Background Cell (Excel 2000)
default command? (2000)
Chart (Excel97 SR-1)
OCX objects and others (Excel 2000/SR 1)
Macro exists? (2000 SR1a)
PassWord Loop (2000)
DSN-less ODBC Connect (OFC 2000 SR-1)
Standard Code Module On The Fly (Xl2000/2002)
Calculating % change (Excel 2000)
Age Calcs (2000)
cell data restriction to only accept a number (97/2000)
checkmark in IF stmt (Excel 97)
Excel Data Comparison (Excel 2002)
Aligning Controls on Forms (2002)
Shared Drives (2000)
Hyperlink to A Chart Page (2000)
Excel (2002)
Need help with these loops (Excel xp)
Template for international spreadsheet? (Excel 2K SR-1)
Unprotect sheet when user clicks a certain cell (2000)
Task pane toolbar not visible on starting Excel (Excel 2002/SP-2)
Extract Cell Contents (Excel 2000)
Validation list using multiple workbooks (2000)
Printing address labels (97)
Cumulative values chart (XP)
if/or reference to another cell (2000)
Wrap text in a cell whose column is too short (2002 SP-2)
Pasting Excel Charts (2000 SP-3)
Format cell ref with number format (Excel xp)
Can't stop this loop (Excel xp)
using tab key jumps from column A to k (excel 97)
Illegal Operation (Office 200 SR-1)
Russian Language VLOOKUP (2000)
Multiple text colors within a single cell (Excel 2000 SR1)
Run-time error '438' (Excel xp)
Add-In's (Excel 2002)
Format numbers depending on case of letters (excel xp)
Help with Send Email Macro (Excel 2000)
Fill macro (Excel 2000)
Excel Template (5.0)
Add a page break (Excel xp)
copy / paste issue (2000)
English american english date problem (00)
Copy one workbook to a different WB template (2000/SR2)
Startup Macro (EXCEL 97 Win 98)
Insert character into a cell (Excel 2000 SP2)
Excel Macro to color my rows (97)
Ugly code needs help (Excel xp)
trigger the code exclusively on a single click (XP)
Using a Bar Code Reader to Enter Data (97 and >)
Excel - Calculating Date (2000)
Copy one workbook to another workbook (Excel 2000/SR1)
Macro to Open Another Excel File (2002 (SP-2))
Excel Is changing my cell contents (XP)
using VLOOKUP command (2000)
Closing a userform with the Esc key (Excel 2000 SR1)
Auditing A Circular Reference (2000)
Checking for Sum of Values (Excel 2000)
How to make a Set statement (Excel xp)
Applying VLookup Code In Sheet (97:SR2)
Copying Formula (Excel 2002 - XP)
Opening Excel workbook with same name (2000/SR1)
returning a row with the smallest number (2000)
Substitute letters in a string (Excel xp)
Excel - Macro's (Excel 2000)
Selection is too large (2000 SR-1)
Importing figures as Values, not text (2000/SP 0)
Large File (Office 97 SR2)
Move letters to next column (Excel xp)
Screen Resolution (xl2000)
Excel - Create Combo Code (2000)
Rightmost column (Excel XP)
Offset Formula (2000)
Find Mean or MEAN or mean (Excel xp)
entering data from workbook to workbook using ref (2000)
Error Message Show (Excel 2000 SP-3)
Loan Calculation (2002 SP-2)
Checking uniqueness (2000)
AutoFilter list limit (Excel2000)
Dynamic references to cells in external files (Excel 2000 / XP)
Formual Needed (Excel 2002 - XP)
Finding cells in a range (2000)
Reset End of Data (2002)
Counting characters (Excel 2000 SR1)
Using an Array for a File Rename (Office 2000 SR-1, Excel2000)
columns command (2000)
Validation List (Ver 97, WIN 98)
VBE References List (Excel 2000 SP-3)
Space in formula (excel xp)
Print to File (Excel 97 )
Output to File (2000)
Advanced Filter Causing Crashes (2000 SR1)
Prevent Named Range Change Whn Row Deleted? (2000 sr1 sp3)
Running total from userform textbox (2K)
Using INDEX in VB (Office 2000 SR-1, Excel2000)
Footer on first page only (Excel 2000)
Is there a way to collapse rows like in MS Project (Excel 2000)
Counting X in 2 different columns (Excel 97)
Excel formula help (97 SR-2 on NT4.0)
Save a value for use later (Excel xp)
MATCH formula performance (Excel2000)
Autofilter via BeforeDoubleClick Sub (97)
Excel and Lotus Notes (97)
Read only access (2000)
Averaging groups of cells through a workbook (2002)
Excel 2K form question... (Excel 2000)
VBA equivalent of Advanced Filter? (Excel 97)
Strip text from numbers (Excel 97 SR2)
How to use the PI function? (Excel 2000 SP3)
Excel 2000 - Save as webpage converting hyperlinks (2000)
Clipart in Header??? (97)
Lookup - exact match (2002sp2 / any)
Suppressing prompt dialogs on deleting a workshee (XL 97/VBA)
String Trimming (Office 2000 SR-1, Excel2000)
Default Formatting for Cell Comments (v97 SR2 and Above)
SetTimer (Excel 2000 SP-3)
Divide text strings (Excel 2002)
VLOOKUP (?) (2000)
Finding matching invoices (XP)
validation list grouping? (IE 6.0)
Autosave VBE objects (97 2000 2002)
Swap Headings? (Excel 2002)
Coexisting Excel 2000 and 2002 (2002)
macro for excel (O2K)
Saving and Restoring AutoFilter Settings (Tested on XL97)
Excel Printing (97,2000,XP)
Adding Data to A Range (Excel97)
Add numbering (2002)
Last edited by (2002)
Formula to Search and Average (Excel-Any)
Hide pasted graphics (2002)
Hour glass during save (2002 sp1)
VLookup prob (2002 sp1)
Briefcase sychronization (O2K SP3)
Copying Formula from corrupt workbook (2000)
Blank zeros? (2002 sp1)
What kind of jobs...
Sending a program instance to Excel (Excel 97 and greater)
Change Size of Pie? (2000)
VALUE# error (Excel xp)
splitting columns (2000)
Corrupted ExcelXP?? (XP-SP-2)
Excel Workbook will not maximize (Excel 2000 SR-2)
next worksheet/chart (XL97 sr2 on Win2000/ NT4)
Naming Ranges in VBA (2000)
Open File for Input (Excel XP)
File SaveAs - Cancel (Excel2K)
Locking the position of Embedded Documents (96/sr2)
Checkbox Madness (Excel 97 SR2)
Vlookup Table Array (98)
Pasting numbers to Excel from Access (XP/SP-2)
T-test in Excel (Excel xp)
What are these things like comments ? (Excel 2000)
Path name in custom footers (2000)
workbook formulas processed before open event (excel 2000/r2)
Data Validation and/or Forms Toolbar (2000/SR-1)
Which dialog to use? (2002 (XP))
SUMIF using between (97; SR2)
How to close an internet connection? (2002 (XP))
How many MS employees does it take (97, 2000, 2002)
AutoFilter and finding the last row (XL97 + Others?)
Month format in EXCEL VBA (EXCEL 97/2000)
Nudge Charts with Keyboard (Excel 97)
Conditional Formatting (2000)
Summarizing Data From Several Sheets (2000)
Queries to External Data on a Template? Help??? (Excel 2000 (9.0.3821 SR-1
Changing form object properties (Excel 2000)
Scatter Plots (97 ST-2)
Excel worksheets disappearing (Office 2000 Premium)
Complex footer code (Excel 97)
ComboBox w/Grouping (XL97;SR2)
Date counting/averaging (97)
Data Tables in Large Models (2002 SP-2)
Automatic charting (2002)
Custom Toolbars and Menu Bars Only (200)
Excel 97 (SR-2)
Message box (97)
VLookup (2000)
A Matter of Time (XL97;SR2)
Cannot Load Analysis ToolPak Add-In in XP (Excel XP)
Maximum number of rows (Excel 11 Beta)
Dates in excell (Office XP)
VBA Flow (xl2002)
Combining cells - both not text (Excel 97 SR2)
Missing Format Cells db (XP 2K)
Permutations (A2k)
Code for Find? (Excel 2000)
Third Party Password Add-in (2000)
message boxes are ignored (Excel 97/Win XP)
Displaying CSV files (IE6/Office 2000 Premium SP-1)
Data lost after inserting and saving (Excel 2000 SR-1a)
Setting Background Color (Excel 2000 SR-1)
Excel CSV export (2000 SR1)
YTD Totals (9.0.6926 (SP-3)
Copy worksheet to end position... (2000)
Advanced Filter (2000)
Protection & LInking (2000)
Filter problem (2000)
Determine Dates (Excel 97 SR2)
Change Pie Colors (Excel 2000)
Flexible find & replace (97 2000 2002)
Apply a Drop Down box Value to a Cell (Win 2KPro, Office2KPro, Xcel2KPro)
Custom menu bar disappears when i select a chart (Excel xp)
.xla back to .xls (Excel xp)
Using The Name Box During Formula Entry (2000 SR-1)
Repeating characters (XL2K SR1)
Range Name in VBA (XL2K SR-1)
unexpected Match result (Excel2000)
Find current blank cell (97)
Range Names (Excel 2000)
Display Comments in Spreadsheet (2000)
Passing tab name into formula (2000)
Embedded Array In An If Statement (2000)
Sppedometer (xp)
Compile Error on Start & Close (Excel 2000 SR3)
Excel - Status Bar (Office 2000)
Pick from List (Excel 97 and 2000)
XY scatter chart (2000)
Send Mail (Complicated) (XP)
excel mailto in empty cells?!@ (xl 2002(xp))
Renaming sheets (Excel 2002)
Where are toolbars saved (97)
TextBox Validation (XP)
Font color different for part of text/formula (Office 2000)
Hyperlinks in Excel 2002 (2002)
Dynamically changing column width (97)
How do I remove a Command Button (2002)
Phantom Auto_Open (Excel 2000 SP-1)
Email other than Excel files (2000)
Input on where to placemacros (Excel 20002)
Conditional Format Based on Two Cells (2002 SP2)
DOCVAR equivalents? (2000)
30-year averages (2000)
TransferSpreadsheet (2002)
Drop-down Data Validation List (Excel 2000/SR1)
Invalid Page Fault (Excel 97)
Refreshed ListBox (XL97:SR2)
Column Width In ListBox (XL97;SR2)
Need Help with macro (Excel 2000)
Index/Match from multiple sheets (2000)
Import macros from Excel 2000 into 2002 (Excel 2002 SP-2)
Variable of TextBox (XL97;SR2)
SumIf with multiple criteria (Excel 97 on Windows NT)
Replace with nothing (98)
Flashing number (2000)
Sum of values (Excel 2002)
Position Active Cell on Opening (Excel2K)
Clearing everything from a worksheet copy (2000/2002)
Delete Leading and Trailing spaces (Excel 97)
Name Manager 2.2 released (97 2000 2002)
Date/Time (XL97)
Check Boxes print too light (2000)
Add Values in Two TextBoxes (XL97; SR2)
Adding every nth column (Excel 97)
NPV Question (Excel 2000)
Clearing Windows Clipboard upon leaving Excel (2000/SR2)
Number Pad v. Letter Pad (?) (Excel 2000/Windows 2000)
Rolling Graph (XP)
pivot item labels (2000)
ATTN: Hans - Spin Button Help, please! (2000 - no SP's)
FIND in formula (Excel xp)
Numbers in a ListBox (XL97:SR2)
Commandbar buttons don't work (Excel 2000\SR 1)
Excel Calculation Question (Excel 2000)
formula for days in a month (excel 2000)
Electronic Signature (Excel 2000)
Remove (or disable) X close button (xl2K)
Excel Macros and VBA (Excel 97)
Unhide 1st Col(s)/Row(s) (2000 sr1)
Compare (2000)
First Cell to Left Not Blank (Excel 97-SR2)
Help with IF Function (Excel '97)
Tab to tab (WINNT OFF 2000)