Windows Secrets
Windows Secrets Lounge
formula returns '' (97+)
floating command button (97+)
Function ShowFileAccessInfo Problem (Excel2000)
It won't take a second ! (excel 2000)
Referencing IP address does not work.... (Excel 2002)
Nominating post entry cell (Excel 2000)
Hyperlink across network servers (All/2002)
Comparing Text (Off 97/XP Pro SP1)
Macros and browsers (XP sr1, i.e.6)
Pivot table: sum at end of month (XP SR 2)
QuattroPro DOS (4 and 5)
Show standard File dialog box (97 sr2, XP sp1)
paste unformatted macro (2000 9.0.2720)
Copy Paste Macro (2000)
Aggregate Scores (97/2K)
Entereing a negative time value (Excel 2000/XP)
Class module events not being handled (Excdel 2000/SR 1)
Pivot table refresh (Excel 97)
Sum using filters (XP SP 1)
Sorting in a Pivot table (XP)
Close without saving (97sr2, XP sp1)
Combobox listfillrange (Excel 2000)
Formula
Date format problems (2000sr1a)
.plugin141.trace (2002)
Search Feature not working (2002 SP2)
Need Array Formula (XL2K)
Phantom ranges (2000)
Gradebook - Loss lowest score (Excel 2002)
Conditional Formatting (Excel 2002)
need formula (97 SR2)
min >0 (97 SR2)
Yellow Highlight of current line in Excel (Excel 2002 / XP)
Update a worksheet from a UserForm (97/2k)
Formula in Excel (Excel XP)
Sticking Select (2002 - 10.2614.2625)
Database Lookup both Horizontally & Verically (XP)
auto date series (97+)
Formatting Protected Cells (Excel 97 on Windows NT)
Repair corrupt Excel names (2000, XP)
Macro to change to a specific printer (Excel 2002 SP2)
Dot leaders in cells? (Excel 2k/SR-1)
Log plot (XL2K) (217032) was removed
Sort by date/time distributing to separate sheets (XP)
Flag record based on Row and Column Criteria (2000)
Check Box Button (Excel 97)
Command Button (Office 97 SR2)
Repeat first row in print on each page (Excel 2000)
Excel Printing Problem (Excel 2000 SR1)
Time elapsed application (Excel 97 SR 2)
Price point line chart (Excel 2000)
Macro Not Running (2000)
Excel Charts (2000)
Convert Chart Series to Array of Static Values (2000)
finding location of template file (excel 2000)
Count Text Cells (Office 97 SR2)
Typing into combo boxes (Excel 2000)
Sorting (XL 2000)
Macro Buttons For Personal.xls Macros (2000)
sumif or VBA? (Excel 97)
Dropping 2 lowest scores (2002)
Macro to Remove Hyperlink (2000 9.0.3821 SR-1)
UserForm Property (97)
CSV files with large numbers (Excel2000)
Dropdown List without VBA Code (Excel 2000)
Importing Bank Transactions and transposing (97)
Run-time error '9' (2000)
Personal.xls File Opens When I Open Excel (2000)
Fix corrupt names utility (2000, XP)
Finding non-unique numbers (97 SR-2)
Worksheet Page Numbers (2000)
Link to a databse (Excel XP / 2002)
Lost protection and sharing password (200sr1a)
Hidden Auto Open Routine? (Excel 2000)
positioning different charts on same location in e (1)
Move to new worksheet (97/2000)
Validating E-mails (97 and >)
Printing a Sheet (Excel 97)
A Macro That Runs Automatically? (2000)
Last Entry In Column (2000)
Keyboard Shortcut (2000)
add-in (2000)
E-mail current worksheet (2000)
Consolidation Using Indirect() (XP)
Checking for references to another sheet (xp)
Find Differences (Office 97 SR2)
Watermark in Excel 2000 (9.0.3821-SR1)
2000 (Indirect Function?)
Summing By Day (2000)
Vanishing Footer (Excel 97 SR2)
If formula (XP)
QFD in Excel? (Excel 2K SR-1)
European Number Formatting (Excel 2K SR-1)
Easy Excel 97 Question (Excel 2000/97)
Looking for a formula (Office 2K SR-1)
Freeze Cells (2000)
Problem with formula (Excel 97)
Find whilst protected (Excel 97 sr2)
Recursive equations in VBA. (Excel 2000)
Controlling the re-distribution of a workbook (XL XP)
Name manager 2.1 released (97, 2000, XP)
Excel 2002 Calculation is Slow (2002 SP-1)
VBA, which point? (XL 2K)
Change Chart 'ToolTip' (XL 2K)
No shift cells? (2002)
Vlookup function (Excel 2000)
Update or insert new VBA module (Excel 2000/SR2)
Keyboard shortcut list (XL97)
Workbook_Open does not fire in Excel 97 (97)
Formula Help (Excel 2000)
Problem signing project (XP)
A problem using class instead of regular modules (2002)
Accessing Outlook contacts in Excel (2000/XP)
Grey Graphs (Office 97 SR2)
Link Removal (2000 9.0.4402 SR-1)
Miles and Yards (97)
paste, link, etc XL2000 (2000 SR-1)
Search thru file and calc formulas (Excel xp)
HTML Error Copying Worksheet (97)
Find & Replace (all)
Workbooks to Worksheets (Excel 2000 SR2)
Formating a Textbox on a UserForm (97 and >)
splitting one cell into two or three (Office XP)
Worksheet name (Office 2000)
Projecting Future Values / Advice (Excel XP)
here's a challenge! (Excel 2000, SR-1a)
Making a nested IF statement simpler. (Excel 2000/SR 1)
Tabs Don't Have Any Colors (Excel XP)
Limiting Access to a Range (Excel 2000)
Worksheet activate event being called over and ove (Excel 2000/2)
Need Formula (2000)
Excel Macros - What am I doing wrong? (Excell 2002)
ExcelXP (Max records)
Viewing All Sheets (2K/SR1)
Code works in VB 6 and Word, but not Excel (97/2000/2202)
User defined functions (XL2000)
I don't like the confirmation dialog...Can I kill (Excel 2002)
Convert a string (Excel XP)
Tracking Changes in Records in Large Database (XP and 2000)
Charts, Pictures, and CPU Usage (XL2k)
Excel Pivot Tables (97)
Difference between a blank and a blank cell... (EXCEL 97/2000)
Refresh chart (2002)
Sorting Protected Worksheet (Excel 2000)
Prevent Excel from removing leading zeroes (2002 SP-2)
add vertical lines to charts (XP)
Disable Save in Template (Excel 2000)
Timesheet on desktop (2000)
Formula assistance (Excel 2000)
Mass Hyperlink Updates (Office 95)
CHR error (Excel 2000)
Function update on load (97/2000/xp)
Too many fields (?) (XL2K SR-1)
New session/workbook (Excel 2000)
Sum of Range (Excel 2000)
MSQRY32.exe has generated errors and will be shut (Excel 2000 SR-1)
IFs can you nest or extend them? (Office 2000)
Accessing an Excel cell
Finicky Find (XL2000)
Sorting Numbers (Excel 2000)
Multiple SumIF Criteria (Excel 97)
compare two columns with B contain A (excel 97)
Get Cell Value Based on Cell Color (Excel 97 SR2)
if formula or conditional formatting (97/2000)
Defined Name range count (Excel 2000)
Sum Offset (XL97;SR2)
Grouping (XL97;SR2)
Access to XL auto refresh (XPSP1)
Userform Maximum No? (97/SR2)
Payroll withholdings (Excel 97)
Row Too Tall (X2K)
File Save Path (XL2000)
Date mask (office 97)
Moving non-hidden rows (Excel XP)
finding matching text (Excel 97)
Using Range Variables in Formulas (Excel 97)
Save As with extension (Excel 97)
Chart printing over many pages (excel 2002)
Movable Toolbar - frustrating (Excel 2002)
'Mission Impossible' (Excel2000)
link excel with access query (Excel 2000)
Formula needs work (Excel 97)
Excel INstalling Microsoft Excel Feature evry load (Excel XP Office 2002 sp2)
User-Defined Function (XP)
Cells (Excel 2K)
Consolidating Cell comments (Excel XP)
Line Graphs (XL.7 SR2)
Protecting Ranges (XL 7 SR2)
Data forms and macros (Excel 2000)
Sys automatically saving to temp doc instead of (Office 2002)
Need Way to Sum 100 Categories (97)
Formula (Excel 2K)
Size of empty(?) WB (EXCEL 97/2000)
Add consecutive number in cell on each sheet (Excel 97)
countif and? (97SR2, 2000)
excel (2000/2002)
Drop Down Boxes (Excel 2000)
Diagram Style Gallery (Excel 2002)
New version of Name Manager!!! (97, 2000, XP)
Merge 3 documents (Excel 97)
Exel crashing (Office 97)
Bottom Scroll Row (2000)
'Save' doesn't save to original location (Excel 97)
Count unique entries? (XL97, WinNT4)
Find method, after parameter (Excel 2000)
Maths problem (2002 sr1)
Counting Unique with an added IF (Excel 2000)
Not calculating (2000 SR1)
Instalaton language (All)
Excel file bloated (XP or lower)
Forwards compatability of Excel (xl2000)
GETPIVOTDATA (EXCEL 2002/XP)
Virtual time line (All)
Pivot Table & arbitrary consolidation (2000k SP3)
Create an updateable Calendar (Excel 2002)
Office extension for Tablet Pc (1)
SORT ROWS (2000)
Compile Error Else without If (Office 97)
Conditional Formatting (Office 97 SR2)
COUNT HELP (MSOFFICE2000)
to sum all the sheets (excel 2002)
formula to indicate percent higher (excel xp)
File format error (Excel 2000)
AutoCorrect File (2000/SR1)
add formula to column (8.0)
Disable Macros in Worksheet (Excel 2000)
Stop New workbook dialog box (Excel 2002)
How does one load/unload a COM AddIn via code (Excel 2000/Excel 2002)
shell program calls (Excel 2000)
showing forms and templates (XL97 sr2 on Win 2000/NT4)
Backwards Compatability of XP (Excel XP)
Value from a control (Excel 2002)
Corrupt Excel formulas (2002)
How do worksheet references get resolved? (2002)
count char instances within a cell (no vba) (Excel 2002; 10.4109.3401; SP-
HELP with VB and Excel (Excel 2000 VB 6)
Another Hyperlink Cell Question (97/SR2)
Excel - Illegal Operation message (Win 98 SE - Office 2000)
Sort but Keep Linked *DATA* (XP SP1)
Quiting Excel from Macro (XP)
No Task Pane (2002)
Is there a quick way to... (2K SR-1, 2002)
Problem Code (97)
Flexible Find/Replace Utility (2000)
xlDialogSendMail (2000/SR-1)
How to change the font size? (2002)
Filtering for text (Excel 97)
Simple Macro?!?! (2K)
Clip Art killed my budget (Excel 2000)
Excel/Word Question (XP 2002)
Drop Down Calendars (Excel 2000)
substitute formula (excel xp)
Excel autosave (2000 SR1)
VBA Update desktop shortcut (2000 SR1)
Excel/PDF and referential links (XL97)
Beginning Excel book (Latest)
Page numbering in fields (Excel 97)
VLOOKUP Anomalies (97 SR2)
Protect / Unprotect (Excel XP)
Text Direction (2002/ SP2)
Sort by date/time distributing to separate sheets (97)
Go to a cell based on selection from listbox (Excel 97)
Pivot Table Sum (2000/SR1)
Cell is truncated between two workbooks (97:SR2)
make green cells (excel xp)
Importing Word Table (Excel 2000)
Excel App losing focus (Excel 2000/Excel XP)
Smart??? Tags (XL 2002)
VLOOKUP confusion (Excel 2000)
Excel Security Issue (Excel)
Charting Advice (Excel 97 to 2002)
Working with Absolute Values in Cells (Excel 2000)
file open & file exit greyed out (Excel 2000)
Changed cell color based on IF statement (Excel xp)
Custom Fonts? (Excel 2000, SR1)
Validate date from textbox (Wni 2000/ Excel 2000 sp2)
Incrementing column value in VLOOKUP Thanks Folks!
Calculations 2 (Excell office XP)
Calculations (XP office version)
Can't Find Link (2000)
Assigning the value in a named range to a shape (Excel)
Merging to Word Labels (Excel 2000)
IF and Date (Excel 2000)
Sheet name changes when saved in CSV format (XL2000)
Language problem (Excel 97)
Clearing the clipboard (excel 97 sr2)
Printing Problem (Excel XP)
Search form (XP)
Date Formula (Excel XP)
Workgroup Templates (Office 2000 / XP)
Duplicates opening (2000)
Change dates from one time zone to another (Excel 2000)
Protecting Multiple Sheets (97)
Multiple Excel Windows (Excel 2000)
Copying List from Photo Editor/Paint into Excel (Excel 2002)
Averaging rows where data is in every other cell. (Excel 2000)
Find first non-null value in an array (97)
Calling COM addin methods (Excel 2002/1)
End-Home (Excel xp)
Week Number (Office 97)
Data Validation + AutoComplete (2000)
making a formula with a variable range (Excel xp)
Importing csv files to Excel (2002)
Advance Filter (Office 97)
Simple link return 0 (Environment: Win2000, Office 2000 pro UK - Sp2)
Excel and VB (Excel 2000)
Annualizing volatility (2000)
Excel/Office Templates (2000)
Protection (XL97, WinNT4)
Add an IF stmt to existing formula (excel xp)
Dynamic range in a Pivot Table (2000 - SR1)
Hyperlink in Cell (97 SR2)
Cursor selection (2002)
Smart Tags - access to host document (XP)
Automatic Numbering (Excel 2002)
Autosum after filtering (1)
Data Validation Formula (Excel 2000 SR1)
Macro not running in XL2000 + Win XP Pro (Xl2k Sr1)
Run macro on Cell Content Change (2000)
Concatenate (2000)
combo box and LinkedCell (XL97 sr2 on Win 2000 sp2)
Populate Userform TextBox's From Cell Range (XL2000)
Time In Excel (Excel 97)
COMAddIns Again (Excel 2002/r 1)
I Need Some Business Data Sets For Textbook (Any)
Pasted Null Value Not Null (97)
Clear locked files (2000 SR1a)
background colour in a drop down list (XL 97 sr2 on Win 2000 sp2)
Menu Item in xla (Excel 2000)
Count different dates (Excel 2000)
Date & Time Diff (Excel 2000)
Distributing an Excel application with toolbars (5/95/97/2000/2002)
Copy onto Piv Tab menu (XL2000)
Format cell 0.00 - 0.00% to show a 0 number result (excel xp)
Dynamic Graph Name (2000)
Complicated formula or macro (excel xp)
Find one letter in a string of letters (Excel xp)
Excel (XP)
excel mail-to on menu (Office 2000 Excel)
Up or Down arrow if text in cell (Excel xp)
Save worksheets as a separate Workbook (Excel)
Checkspell to check a textbox (Excel XP)
Joining Ranges (97;SR2)
Copy/Paste (97:V2)
Resistors Ratio (O97)
IsPageBreak Function (Excel97)
Auto Filter Macro (2000)
Validation No Blanks (XL2K)
File Not Found (Visual Basic Error) (97)
Reading 2002 files (2000)
Multiple sheets (2000 SR-1)
External Data Query based on Cell Value (2K)
Averaging cells (Excel 2000)
Template vs workbook (XL97, WinNT4)
Is there an Excel Reader (all)
Breaking rows across page boundary (Excel 2000)
Broken Link in workbooks (Excel 2000)
How to tell if a range has text in it (excel xp)
Count Cells that contain red text (Win2k, Excel 2k SR-1)
Personal.xls with menu (excel xp)
Turn off Auto Format of HTML (2000)
Excel Add-ins and COM Add-ins (Excel 2002/1)
VBA StarPost Cross Reference (Excel 2K and Up)
returning values from functions (XL97 sr2 on Win 2000 sp2)
Using same cell formats on user forms (97sr2)
Print preview crashed when using wheel to scroll (Excel 97)
Closing inactive workbook windows (Excel '97)
Birthday Code (97/2k)
Cell formatting (Excel 2000\ SR1)
Averaging cells, excluding 0s (Excel 2000)
Counting within a cell (97)
Graph of Pivot Tables (97 SR2)
Timesheet (Office2000)
MSQuery and Left Outer Join (Office XP)
Excel (2000)
Search characters (2000/SR 1)
File Lister Macro (Excel 2002)
Date Format (Excel 2000)
Grouping (Office 97)
Best Practice - Using Links (Excel 2000 SP2)
Find and Replace (Excel 2000)
interactive row hiding / unhiding (Excel 2002)
Hiding All Extra Rows and Columns (97)
Preserving formatting (Excel 2002)
Linked Files (Office 97)
Save to specific folder (Excel 2002)
Header with dates automatically populated (97)
Using a COM-AddIn for Excel (2002/1)
countif between two dates (2000 SR1)
Name manager new release BETA (97 2000 2002)
Check Mark Macro (Excel XP)
Labels to txt (Office 2K)
Protected Shared Workbook (XL2000 SR1)
Option Group (Excel 2000)
Default location of links (97 Sr2)
Skip File which is Open-Password Protected (97+)
Splitting/Parsing Names (97 Sr2)
need macro to stop after last page (Excel97)
Adding a button to a form (Excel 2000)
forumla needed for grouped sheets (2000 excel)
Split a cell (2000)
Links (97 sr2)
Macro Password Protect Doesn't Work (Excel 97 SR2)
Format data copy from Web Site (Office XP Windows XP)
Finding a value in an array (excel 97)
Macro for chart labels (excel xp)
transfer names to new workbook (excel 97)
Page Numbering in a Workbook (2002)
Flaging Dates with Conditional Formatting (Excell 2000)
Macro not working (2000)
Automation with Lotus Notes 5 (5.0)
Generating a List (Excel 2000)
passing a range of cells to a VBA array (XL97 sr2 on Win 2000 sp2)
What could be the formula? (XL/2002 - SP2)
texts in diagrams (Excel 2002)
Fill in of Cell with Macro (Excel 97)
Apply formula to Selected Cells (Excel 2K)
Application.caller Help (2000 sr1)
Lookup on different page (Excel 9.0.3821)
Multi-column Validation list (Excel 2000)
Clear Row Contents (Excel 97 SR2)
AutoSave Default Time (Excel 00)
invalid name for VBA function (XL 97 sr2 on Win 2000 sp2)
UserForm help (97)
Retain Comments in HTML? (Excel 2000)
Excell contact hyperlink (2002 SP2)
Cum Frequency scale (2000-SR1)
Search and Insert txt from external file (Excel 2002)
Formula for times (excel 2000)
absolute values of array elements (XL 97 sr2 on Win 2000)
How to use the same function with a shortcut? (XL 2002/SP2)
importing data (97sr2)
Add-in UDF's (2000)
COUNTIF using two arguments (Excel2000)
formula for criteria (2000 sr1)
Summing by Attribute (Excel 2000)
Links (file not found dialog) (2000)
Column or bar chart percentage labels (97)
We need Beta Testers for new Auditing Tool (Excel)
typing in worksheet (excel 2000)
Message box wil Yes/No option? (97)
Searching for File Contents (Excel 2000)
Does Excel 97 Support Hyperlinks (Excel 2000/97)
Complex Formula in Name (Excel 97-SR2)
Filling gaps (2002)
Finding errors with VBA (2000sr1a)
3 dimensional charts (All versions)
Extracting Data Table Formula instead of Value (Excel XP)
calculating business days (excel 2000)
Macros in Excel (Office 97)
Adding in a formula (Excel 2002)
How do you add a paper size to Page Setup? (2002/9.0.4402 SR1)
convert hours:minutes to number of minutes (Excel 2000)
Tracing Dependents to other Worksheets (XL2000 SR1)
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)