Windows Secrets
Windows Secrets Lounge
how to convert excel into access table (Excel 2000)
Error Message (Excel 97)
Disable the F1 key (XL 2000 SR1)
Financial Calc (2002 SP-2)
Proper function (XP SR-1)
Creating and using DLL's from C# in Excel (Excel 2000)
checking data...in excel (2000)
error ole (2000 sr 1)
formula to find file mod. date of exel file (2003)
Vlookup...I think (Excel 97)
Print column titles on all pages? (XP)
'unique' Filter criteria (Excel 2000)
Code assistance for macro (WINXP Excel 2000)
ADO ADODB.Connection (2000)
Problems with Functions (Excel 32003)
pull-down choices ('97)
Cannot disable macros after digital signing (Excel 2002 (xp) SP2)
count no duplicate value (2000)
excel XP strange (2002 (10.6501.6626) SP#)
Constant file not founds (2000)
SUM function don't work (Excel 2000)
Conditional Format for public holiday (Excel 97)
If function or Change Event? (2002)
Outline v Subtotal (2000+)
Automatically Caculate Bills Needed (2000,SR1)
Copy & Paste Text (XP/2003)
Data acquisitioning in excel (Excel 98 )
Wrap Custom Format (2000+)
ASAP Utilities (97-2003)
Default Template (2003)
Crystal Ball v. @Risk (XL97 / 2K)
Formula Entry is Text (XP)
Automatic Print Paper Size Reformat (Excel 2000)
I probabaly have something better to do (2003 115612.pii)
Macro to hide rows in Excel 2003
fit to the left (2000)
Outlook t Excel (MS Office 2002)
Goto source cell (2002 SP-2)
Time Calculation between two dates (2000 SR-1)
Multiple calculations = Multiple IFs? (Office 97)
Using month in Concatenate (2000)
Return date for max number (2002 SP-2)
16 weeks Hence (Office 97)
calculating results on a subdatasheet (2000) (364722) was moved to the Access board
dates corrupted on import (2000 SP3)
Sorting problem with negative value (excel 2000)
UserForm (XP)
Ctrl+Enter (Excel XP)
MID Formula in VBA (XP)
loops to update new data (2000)
Displaying Pivot fields (Excel 2000)
loops for columns (2000)
Automated File Creation (Excel 97)
How to make maps (O-XP)
Running Total Formula (XP)
VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)
deleting non-duplicate rows (xp)
Where the Excel template is at (Excel 2000)
Bogus 'Data Consolidation' warning on HTML Save (9
Save to Web Page problem (2003)
Getting rid of (blank)s in Excel 2003 pivot tables (2003)
IMPORT 2 TABLE ... (2000 sr 1)
Will wrokbooks open OK in Excel 97 (2002)
contour plot (Excel 2002)
Parsing text in a cell (2000 SP3)
modifying sheet code by VBA (Excel2000)
Parsing data in a cell (2003)
Excel and Documentum (2002)
Formula Assistance (XP)
Adding two dates for time (MS Office - Excel 2002)
Conditional Formatting - Borders (Excel 97)
Command Button question (Excel 2000)
Automate import text files (Excel v2002)
Selection does not turn off (Excel 2000)
import one SS into another (2003)
double underline vs. double accounting underline (Excel 2000)
NETWORKDAYS (2000)
Drop the Lowest Score (Excel 2002)
Adding custom Header/Footer to Default Listbox (Excel 97)
Converting HEX Values (EXCEL 2000)
Looking Up Column Headings (2002)
Most Recent Files Stuck at 4 (2000/9.0.3821 SR-1)
Select Macro (Excel 2002)
Learning Querys (Excel 2000)
Problem with Personal.xls macro worksheet (2000 SR-1)
Formula for unique values (Excel xp)
Pasting Text in Excel Doc (excel 2000)
vlookup and combobox (excel 2000)
Searching for Question Mark symbol in Excel? (2003)
Cursor movement & Command Buttons (Excel 2002)
Importing from Excel (Ex 2002) (362366) was moved to the Access board
Filesearch (WXP, OXP)
Pivot link (xp)
Won't Unprotect (2003)
Removing Hyperlinks (Excel 2002)
Printing to Acrobat 6.0 (XP)
Using ANd or and If statements (excel2000)
Error Message (2003)
Concatenate (Excel 97)
*** in password field (2003)
Can't open file (excel 98)
close all worksheets (office xp 2000)
How to analyze this data (97 sr2 or 2003)
Save file on close (Excel 2003)
Nested Formula - 'VALUE' result (Excel 2000)
Pivottable autorefresh (Excel 2003)
Variable size indexing (2002)
Change Data Labels (XP)
Date of Pivot Table refresh (2003 / 11.5612.5703)
Excel - linked formats (2000/sp3)
Excel Protection (2000 9.0.2720)
Locked for Editing (2K)
Duplicate Entries (2000)
Access man needs help (2002 SP2)
Return column number? (XL97/WinNT4)
Password Access (2002)
Separating text in a column (XP)
Nested (?) sub-totals (2002)
dynamic titles for charts ('97, SR-2)
data labels ('97, SR-2)
Track Changes->History (Excel 97)
Finding Text within String (2000/SP-3/VBA)
Pivot Limits (Excel 2000)
Directory of Personal.xls (xl97, Win2000)
Auto Date command? (2000)
Font Colours (Excel 2000)
Workbook Printer Driver Dependency (2000 SR1)
Formula in Chart title (2002)
Listbox Item Delete (XP)
ActivePrinter and 'Ne01' designation (Excel 2002 (xp) SP2)
Monthly Automatic Updates (Excel XP)
Check for Duplicates across two workbooks (Excel 2002)
Centering Text in a Label (XP)
calculating only new sheet appended to a workbook (Excel 2002)
Can I rename a sheet tab based on cell info? (Excel 2000, SP-3)
Financial Statements (Excel 2002 )
ComboBox (XP)
How Many Days (XP)
HP7750 Plotter? (ExcelXP)
Toolbar button (2000)
ActiveCell in Another Sheet (XP)
Linking data to secured database (2000)
Counting string occurrences (XP)
(if and) formula not right (excell 2000)
Data Consolidation (Excel 2003)
Unable to move focus to different cell (Excel 2002)
Proper IF syntax (Excel 2000)
Editing problem on Excel (2002)
Intercepting ESC-key (97,2k)
Open File (XP)
Editing Cell Comments (XP)
Reseting the last cell on a worksheet (Excel 2000 SR-1)
Highlighting of a control element in a UserForm (Excel 2000)
Checking for a linked file (Excel XP)
format blank cell to display zero (Excell 2000 9.0.3821 SR-1)
VBA Term for 'Select Sheet' (Excel 97)
calculate total hours (2003 or 97sr2)
Use a UserForm? (2000 / SR-1)
Search within a Date Range (Excel 2000)
two column conditional format (Win XP / Excel 2k)
Embedding Help in Workbooks (XP)
task in Excel (2000)
Percent number formating
Macros (2000 to 2003)
FAST COMMAND WITH CTRL (2000)
Combobox Change event (2000)
Delete lines at end of file (WINXP Excel 2000)
Pivot Tables (97)
custom formatting lost ('97)
Excel Error (2000)
Retrieving info in Excel (2000)
Startup with Shift Key (2000/SR-3)
Pivot table grouping (office 2k)
Macro from Macro using Shortcut (Excel 2002/SP2)
How to calculate Easter (All?)
Create ASCII table (2002)
List files from Folder (Excel 2002 (xp) SP2)
Relay Score Worksheet (Excel 2000 (9.0.2720))
Email Addresses (Excel XP)
Floating bartitles (Office 2000)
Match/Index (Excel 2000)
Restricting Workspace and deavtivating menu (2002)
Sort a Growing Range (Excel XP)
Trigonometry (2000)
Excel & Versions (XP)
Form vs Form (2000+)
Fit to scale (Excel 2k)
Average 'Overload' (Excel XP)
Calculating hours between dates and times (2003)
Anding (xp)
cell format problem (2000)
text boxes III ('97, SR-2)
html to .xls (Excel 2000)
Lookup value in table (97/SR1)
Autofill Dates - Excluding Weekends (2000)
User form (2000)
UK Phone Numbers (2000)
Formula - False when Should be True (Xp SP-3)
Date functions that don't automatically update (Excel 2000 SR-3 (?))
text boxes II ('97)
text boxes I ('97)
How do I show a file dialog box? (Excel 2000 (9.0.6926 SP-3))
Vlookup (Excel 2000)
Using dcount with text values (2000sp3)
Help with Formula (Excel 97)
Extract text to a file (2000)
Saving as Tab Delimited (2000 )
File Opens Twice (97/5.0)
Too few parameters (2000)
Sorting Sheets within a Workbook (2000)
Values Instead of Formulas (2002 SP-2)
Wilcards in IF statements (XP)
Excel Mail Merge (Excel 2000)
Protecting sheet problem (2000)
Arbitrary lookups in VBA (2000)
Returning the cell reference with array formula (2000 SR-1)
Small Business Spreadsheet (Excel 2002/2003)
delete entire rows if... (2000)
Protect and copy (2000)
Sending sheets by email (2000)
up date list (excel )
Displaying 0.5 as
SUM of True/False (Excel 2002)
IF Formula (Excel 97)
apostrophe replacement ('97, SR-2)
Solver-Save/Load Model (Excel XP/2002)
Remove Calendar Control (2000)
Subtotals & Worksheet Protection (Excel 2000)
RAND() Fix (Excel 2003)
How is it doing that? (Excel 2000)
Insert Row (2000)
Cell Reference (Office 2000)
Chart sheet not showing in landscape (OXP)
vlookup (2000)
COMPARE AND DELETE LINE (2000)
Sort Question (Excell 2002)
Formula request (2000)
more then 3 conditions with conditional formatting (XP/2003)
checkmark ('97, SR-2)
Compress Excel (Excel 2000)
Excel vs Access (2000+)
Help needed creating an array formula (2003)
Need Help With Combo Box (2000 9.0.3821 SR-1)
Pagination in Excel (2002)
CSV keeping format (2002 SP-2)
Crystal Ball (2000)
Can't get YAxis label to center (2003)
XL 2K macro not working in OfcXP (XL XP)
PC Mag responsible for RAND Fix! (2003)
Open Access Report in Excel (2002 - SP2)
NAme Manager 3.0 released (97, 2000,xp,2003)
headers and footers ('97)
i need a mcro to rdering by color line (2000)
Access Code Prompts for Multiple Copies (2002 sp2)
Copy Macros and Toolbar to Another User's PERSONAL (Excel 2000)
multi-sheet formula (2000)
Stupid Reviewing Toolbar (Excel 2002)
Help with Excel Task (2002)
COLORED A TAB OF SHEET (2000)
Save as csv (Excel 2000 Sr-1)
Datavalidation (XP)
Updating SQLServer from Excel (2000/XP)
Excel function for all caps (Excel 2000)
formula for monthly data (9.0/2000)
'Split Axis' Charting (Excel 97, SR-1)
Negativ Dates & Times (XP)
macro issue (2000, 2003)
Viewing help (2000)
More Colours on XL Palette? (XP)
Countif (2002)
Macro (Excel) (2002)
'Like' Operator Formula (Excel 2000)
Conditional format blank cell (2002, 2003)
phone bill challenge (all)
Sorting a list with a hyperlink field (XL2000)
xl on the web (2000)
Format Menu (2003)
Dropdown list (Excel 2002 & 2003)
Averaging Time (Excel XP)
Conditional Formatting Problem Solved (XP - but probably earlier as well)
Huge File size (Excel 97)
Need help with Formulae
VBA Control Button's Font Size Attribute? (XP)
XL White Background? (XP)
Links formatting (Excel 2000 SP-1)
File association problem (XP)
Wheel mouse with VBA (Excel2000)
New Autosafe version (2000, 97, XP)
Flexfind (5/95, 97, 2000, 2002)
Words on screen (XP)
Update to flexfind (97, 2000, 2002)
Update to Autosafe (97, 2000, XP)
Update to Name Manager (97 2000 2002)
Autosave VBE objects (97 2000 2002)
Stephen Bullen's Website (All)
button to open folder (97)
date window (excel2000)
Extracting Information (2003)
Macro execute from another work book (Excel 2003)
Macros in Excel (Excel 2000)
runtime error 91 (Excel 2000)
Paste Special -> SUM (Excel 97)
Data Validation using source from other worksheet (97/XP)
PDF to Excel (2000)
Chart Percentages Incorrect (Excel 2002 (SP-2))
Fill cell - on screen but not print (2002 SP-2)
Print Multiple Ranges (Excel 2002 SP2)
Last value before empty in Column (2002)
.pdf documents Import (2000)
remove blank spaces after cut and paste (Office 2000)
Function (Excel 2000)
Incorrect Result of Formula (Excel 97)
Look Up Table? (2002)
Opening Excel Attachments in Outlook XP (XP)
Extracting Data (2002)
Countif (2000)
Populate one spreadsheet from another (2000)
Multiple condition Sum: syntax or logical error? (ALL)
Looking Back At Dates (2000)
Date series excluding weekends AND holidays (XP)
How count cell contents based on multiple criteria (Excel 2002)
Adding lines to a sheet (Excel ver. xp)
Check Box (2000)
Beginner Excel VBA Course (All versions)
Formulas stopped working (Excel 2002/SP-2)
Excel won't load (2000)
Rank Subtotaled amounts (2000)
Help with Calculating Time (Excel XP)
Pasting Named Ranges (2000)
Print to Distiller (Office 2k)
Position of X-axe labels on graph with neg. values (Excel 97)
Faulty Macro? (Excel 2002 NL)
MsgBox (office xp)
Weekday Function (ExcelXP)
Copying Subtotals (XP)
Combo Box (2000)
State of menu items (Excel 2000)
File Copy & Rename (02)
Where Are Query Codes ? (Excel 2000)
Function to eliminate duplicate entries in columns (2000 - SP-3)
Moving a toolbar (WINXP Excel 2000)
Links on / off (ExcelXP)
Error Message (2000)
RE: Enabling Macros (Excel 2000 SR1)
Worksheet_SelectionChange (excel 97)
Date and Text Fomula (2002)
Number & Text (2002)
Cannot get Workbook_BeforeClose to run (Excel 2002 SP-1)
Nested Function Returning False (2000)
fill column (2000)
Nested IFs (Excel 2002)
Change a Whole to Decimal (2000/SR-1)
Mechanising 'bulk' calculated field creation (Office 2000 )
Strange Graph (2002 NL)
Extracting currency from format (Excel 2002)
cell reference in a worksheet (office 2000)
calendar control on WORKsheet (Excel97SR2)
Conditional Formatting (Excel 2K)
find rightmost positive cellvalue in a row (excel2000)
Concatenate (Office 2003)
Data Compare from 2 lists of data (Excel 2000)
Hidden Workbooks (2000/9.0.6926 SP-3)
Deleting links in files (2000)
Saving info in EXCEL (ExcelXP)
Excel and Win 98 SE (5) (350463) was moved to the Windows 98 board
Removing a command from a Menu (Excel 2000)
Win 98 (SE) and Excel 5
Export Fixed Width (Excel 97 )
How to ignore text (2000)
Add-in not Recognized (2000/SR-1)
sampling without replacement (2002)
X-axis labels (2003)
Unhide Sheets (xl 97)
Excel.exe (2000 SP2)
Missing 'Open as read only?' prompt (excel 97)
Charts on Worksheets: plot-areas & textbox sizes (97, 2K)
Conditional formula (2000)
Strange Auto Correct (2003)
Negative Numbers (2000)
Mimic Pivot Table (2000/XP)
Measuring remaining free memory within Excel (xl97,xl2k)
VBA AutoFill Code (2002 SP-2)
Lookup and cell Refrence (Excel 2000)
Run Word thru XL? (XL97/WinNT4)
File Locked for Editing (Excel 2002 SP2/ Win XP)
Calculate Last Date of Prev Month (2000/SR-1)
Conditional format: can't define text font (all?)
Macro security via Automation (Excel 2000)
Pasting cells into e-mail (XP/Excel 2000)
Specify length of Input Row (XP/SR-1)
Hyperlink in Excel (2000)
Viewing remote workbooks (97 sr2 on XP)
Functions Help (xl97)
searching a range for a specific string (excel 2000)
Lokking for the correct formula to use (Excel 2000)
Sum in ExcelXP (ExcelXP)
Printing Fonts in Grey Color (Excel 2000)
Limited Access File (Excel 2000)
Convert to Text File w/Returns (XP)
Public function (97 SR2 on XP)
Copy Paste (2000)
Copy&paste into merge cells (ExcelXP)
Excell XP (XP)
command bar in excel window (office xp windowsxp)
Delete Dashed Lines (all)
Query manager (97, 2000,xp,2003)
Name Manager: fixed 255 char limitation (97, 2000,xp,2003)
XL attachments (2K SP3) (347562) was moved to the Internet Explorer board
Hot links (Excel 2003)
Disable/enable sheets tab delete sheet (excel 2000)
If Function Trouble (Office 97)
Pivot macro problems (Excel 2000)
File prints differently on 2 machines (97Sr2)
Text String Search Formula (Excel 2002)
Cell References in Headers (Excel 2003)
feet and inches (2002)
Excel/Project Tutorials (Office 2003)
Create category totals (any)
Macro hot key (Excel 2000)
Cell Format (Excel 2000 SR-1)
Count if 2 text values are true (Excel 2002)
Using Text in a Formula (Excel XP)
SUMIF or array on two criterion (XP)
find text in a single row (XL2000 sr1)
conditional formatting (2000)
Left Function and Text (2000 SR-1)
sort numbers and letters (excel 2000)
Calculating a date (Excel 2002)
Non-copyable Sheet (Excel 2000)
Save Buttion/Save As Selection (2002)
MIrrored File (97 Sr2)
SEARCH function (XL2k SR1)
Copy & Paste Method (Excel 2000)
Indexing Excel (Excel XP)
Expanding Cells (Excel 2000 9.0.38)
email event (Excel 2000)
formula unknown (excel 2000)
Email Summary sheet (2000)
Excel problem (Excel 2002)
How to Count number of items in a sum formula (97)
Importing text file (2000)
2 Excel Sessions (Excel 2000)
SUM PART OF A LIST (2000)
Corrupt Defined Name Formula (Excel 97-SR2)
SSN Conversion / Losing Leading Zeros (2000)
Seperating numbers and letters in a cell (2000)
MS Project VBA Export to Excel (2000/9.0.6926 SP-3)
Copies of file (XP)
macro redundancy (97)
Hide Code Execution (2000)
VBA to Enter Formula not Value (2000)
Move to new row in list (2000)
simple 'tamper' detection (Excel 2000)
lost macro password (2000 SR-1)
Gap both sides in XL table? (XP)
WS Change stops working (2000+)
Mixed sheet refs (2000+ ?)
XL Watermark? (XP)
mail and print (excel 2000)
Freeze Panes Question? (XP)
Footer Problem (length?) (XL 97/2K)
Sorting on Pivot data (excel 2000)
If Or (XP)
pivot tables (XP)
Remove multiple string (2003)
'Transposing' columns (2000)
GetOpenFileName (ExcelXP)
vanishing toolbar customisation (XL2000)
Paste Function with Dates (Excel 2000)
Tabbing into locked cells (XP)
Row information cut off (Excel 2002)
Copying sheets to a new workbook (200)
I need a SUM IF and PRODCUT in the same formula (excel 2000)
Advanced Filtering Unique Records (XP)
Can't change reference to msquery source (XP)
Paste to new sheet (2000-SR1)
Name Conflicts (2002)
Hide Rows & Exclude from Calculation (2000/SR???)
Reset a chart's index number (Excel 2K, Off2KPro, Win2KPro)
Sychronizations (97 sr2 )
Get UserProperties from Outlook (XP/SP1) (345135) was moved to the Outlook board
Editing the VBE with Code (Excel 2000 SR-1)
Cumulative calculation (9.0/2000)
Entering Music Track Times (all)
page numbers and printing (xp)
wrapping text (xp)
Validation List (2000)
Editing duplicate rows (XP)
writing a macro (excel 2000)
Looping Code (xl97)
Excel Error (2000)
More Complex Cumulative Total Bar? (XP)
Custom userform checkbox won't always work (xl97 xl2000)
Create Totals for Specific Months Automatically (ofiice xp)
Can XL have a Cumulative Total bar? (XP)
How can I copy specific content from other cells? (excel 2000)
How can I force Excel to always open .prt files? (2000)
SUMIF based on font color (XP)
Duplicate Footer throughout spreadsheet? (XP)
Count spaces in text (XL2k SR1)