Windows Secrets
Windows Secrets Lounge
Cell Name w/ cell content part of name (Excel 2000)
Importing to Excel (9.0)
Google desktop and Excel (2000,xp,2003)
text to link (excel2000+)
NETWORKDAYS Function.. (2003)
counting certain cells correctly (Excel 2000)
Conditional Format (Excel 2000)
ALL WBOOK ARE CLOSED... (2000 sr 1)
Change text globally (Excel 2002)
Access macro from worksheet (Any version)
Parsing cell contents (Excel 2000)
Multiple Max/Min Values (XP SP-2)
TMP copies of XL files (excel 2000 (SP3))
Save Embedded Objects (2002 SP3)
Deploying xla (Office 2003)
Display item in different col (MS Office 2003)
Can you disable Undo? (Excel 2003)
global dimension (2000 sr 1)
Transition Navigation Keys (2000)
formula-help (Excel 2000)
Re-Sizing Table (Excel 2000)
MS Excel calculation bug or Pentium processor bug (MS Office Excel 2003 v1
Folder-workbooks (Excel 2000)
New Menu Items (XP)
WHY NOT WORK? (2000 sr 1)
insert dates HELP! (excel)
Red X (Excel 2002)
Separate Execution? (2000)
Mirror a tab (Any version)
The address of this site is not valid. (MS Excel 2002 SP3)
Opening workbooks (Office 2000)
Line/Bar Chart (2002-SP2)
condition... on 2 column (2000 sr 1)
Excel Shared Files (Excel 2002)
List of non-duplicated values (xp)
Location of executable (Office 2000)
vlookup function (2000)
Show a progress bar on the status bar? (Excel 2000 >)
Active row - column G & H - call macro if unmatch (excel - 2000)
Major UDF Problem (Excel 2000 >)
Code to select cell 1 column left to active cell (XL 2002 SP3)
Converting time/assigning values/I don't know?!? (Office XP)
Round down? (Office XP)
Custom Numeric Format (Excel 2003/2002)
Formulas (Excel 2002)
Invalid outside procedure (xp)
Automatic summing (sometimes) (2000 and XP)
Icons (Excel 2000)
Metric vs Stnd, Currency in Global Spreadsheet (2K
Two lists (excel 2000)
insert field (97/2000)
Excel Template in XLstart (Windows XP/Office 2003)
Edit Legend Lables (2000)
VBA for Excel (2000 - 2003)
Google Desktop - Excel VBA problem (All)
Data Analysis (Excel 2002)
Sort currency (excel2000)
Test if cell contains hyperlink need help (excel2000+)
Worksheet_On Open Event (XP)
Pivot Table Filter or Something Else? (2002)
Test if cell contains hyperlink (excel2000+)
workstation location (Excel 2000)
Text to Columns (Excel 2K)
advanced filter/uniique records only (xp-sp2)
Manual Line break in a cell (XP)
Import text file? (2003)
Links Frustration (2002/2003)
How two fix bust autofilter?? (Excel 2000 SR1)
CountIf in filtered list (2000)
Side by side pie charts (Excel 2003)
Aligning Text (Excel 2003)
Spell check error (Excel 2002)
Conditional number format - Possible? (Excel 2000)
Assigned macro gets lost (ExcelXP)
Export Excel data to Banner (Excel 2002)
Changing Formating (Excel 2000 Pro)
Repetative Task done with VBA code (Excel 2000)
Changing Range Names (2000)
Advice on best approach! (Excel 2000>)
UDF argument help! (Excel 2000 >)
Very slow start up (Excel 97 sr2)
Macro to Personal.xls (2000)
Conditional Formatting (2000)
Delete Duplicates based on another field (2000)
Leading zeroes in .CSV files (XP)
Passing Array Variables (XP; SR 3)
IF - testing condtions (Excel 2000)
How to? (Office 2002 SP3)
sorry for this problem... (2000 sr 1)
REFER NOT VALID (2000 sr 1)
Matching Cells (2000)
SumIf and Sum Wildcards (XP: SR2)
Is This Possible (N/A)
Inserting multiple rows (2000)
Transpose (Excel 2000)
Data Validation (2000)
Open excel in groupwise (office97/gw6.5)
Time calculations (2003)
formula based on a string (2003)
Run-time Error 13, Type Mismatch (2000)
spit+sip=tips (2000)
Macro opens input box only on Template (Excel 97 SR2)
How does conditional formatting work? (2003)
Cell Relationships (2003) (432527) was removed
Count of Nulls (Excel 2002)
Activation notice (Excel 2002)
Percentages (Excel 2002)
Side-By-Side Data Fields In A PivotTable (2000)
Counting like a clock (2000)
Combo Boxes & Formula's (2003)
Counting unique (visible) items (Excel XP)
Keeping Rows together (Excel 2000)
Creating Complex Chart (XP)
statistical analysis (w/attachment) (excel 2000)
statistical analysis (Excel 2000)
Tennis Scores (Excel 2002)
Paste Special macro (2000)
delete a read-only file (XL-XP/2003)
delete rows macro (Excel 2000)
Manual Calculate Part Of A Worksheet (2000)
Calculation (XP)
Formula for conditional subtraction (Excel 2000)
Macro to copy cells from previous worksheet (XL 2002 SP3)
VLOOKUP problem (Excel 2002)
Macro to sort variable length list (Excel 2002/SP3)
for the wizard Hans... Insert record in the userfo (2000 sr 1)
Disk error on open (2003)
MS Query and cubes (Excel 2000)
Macro to check cells in range (Excel 97 SR2)
Custom Views Col Widths (2000 & 2002)
Excel - Changing a value of a checkbox with VBA co (Excel 2000)
WHY THE MACRO FIND ... (2000 sr 1)
FILL IF IS BLANK (2000 sr 1)
Can't open because of a macro? (2000)
.csv inconsistent behaviour (XL 2k)
Excel will not open from Explorer (Office XP)
MSKB article question (excel 2000)
formula help (97)
Modal UserForm (XP; SP3)
IF F'n Date logic (Win2000&up; MacOSX)
Hidden rows within groups (Excel 2000)
unknown range (Excel 2000)
#DIV/0 (2000)
Creating a linked Order Sheet (Excel 2003)
Finding records that do not match (XP; SR3)
Read Code Modules (2002)
Query Access Data via Excel (Excel 2003 (others))
Unique List (2000)
Stopped Calculating Data (Excel 2000)
Average (2000)
Adv. Filter help! (Excel2000>)
Performance problems w/o calculations in XL2003 (Excel 2003)
Find in custom functions (2000sp3)
intercept the line (2000 sr 1)
Non-printing characters (2000)
eleiminate ' (2000 sr 1)
aTTENDING TIME OF PROCESS (2000 sr 1)
AutoFilter No Work (2000)
Spinners (Office 97 -SR2)
Export a pie chart? (XP)
Fonts (Office & Windows 2k)
Linking Drop Down Menu's (2003)
Formula, function problem (Excel 2000)
Merged Cells (2000)
Sum (Excell 2000)
sort by dates with inconsistant format (Outlook 2000)
Header color (EXCEL 2000)
Opening Same file multiple times (Excel 2000)
Copying Row Height (2000)
Unlock cell on condition (2003) (2003)
Highlighting part of a cell (xp)
Which Directory (XP; SR2)
Locking a sheet, but not the headers/footers (2000)
Query SQL dissappearing (2003) (429187) was moved to the Access board
Concatenating cells (Excel 2000)
Opening forum attachment leaves hidden instance (WindowsXP) (429007) was moved to the Windows XP board
Easy Excel Problem (Office XP)
History of entry (2000 sr 1)
PARSE (Excel2000>)
The Secret Dialogs of Excel (Excel 2000 >)
GET.CELL function (Excel2000>)
Data Validation Stopped Working?? (XL 2002)
Macro shortcuts for Add-ins (2000)
merge with Excel data source (Excel & Word 2003 SP1)
projecting future from past information (office 2003)
Lookup city/state combo (Excel 2003 (all))
macro strat with a condition (2000 sr.1)
Add simple radio buttons to excel document (MS Excel 2002)
Command Button to Print (Excel 2000)
move/copy worksheet (Excel 2002 SP3)
UNABLE COMANDBUTT (2000 sr 1)
Counting comments (Excel 2000)
Ampersand in Header (any)
Extract Text with space (Excel 2002)
Digital cert ignored in High security (Excel 2003 (all))
Naming cells (2003)
Auto copying between worksheets (2000)
CSV file (2003)
IF Function (Excel 2000)
VBA code in a macro (Excel 2000)
Excel Name Range problems (Excel 2003)
memory management (Excel 2000)
value cleared with scroll bar (2000 sr 1)
Finding Links to Other Workbook (Excel 2000 SP3)
Link or Formula to pull Outlook GAL details (Excel 2003 / Outlook 2003)
Text doesn't wrap (Excel 2003)
multi area range name (2000)
Remove Text (2000)
Excel Macro accessing a Web page (Excel 2000)
Conditional Summing (2000)
Solver question (XP)
Slow Calculate Excel 2003 (Excel 2003)
Find user whos locked worksheet (2000)
commandbars position (XL2000 sr2 on WW2K sp2)
Customised excel formulas (97/SR1)
Copying whole worksheets (Excel 2000 SP3)
error trapping (XL2000 sr2 on W2K sp2)
Edit Links (Excel 2000)
Mixed integers and text in a column (2k)
ASCII Combobox (Excel 2000)
joined file.... (2000 sr 1)
Search in Sub folder (X97-->)
SOLVED: MULTIPLICATE * 1 (2000 sr 1)
Averaging (Excel 97)
CUMPRINC formula (2000 sr3)
excel file name (Ver 2000/SP3)
combine multiple books into one book (Excel 2000 SP3)
conditional formatting (2000 sr3)
Text in SUMPRODUCT (Excel 2000)
Max Num of Sheets (any)
lookup between sheets (Excel 2002 SP1)
macro to open a file (Excel 2000)
VBA Finance and Math Site (1)
Ctrl + Insert to Copy (Excel 2003)
Using a lookup and retrieving a number of rows (XP)
wrod wrap in a msgbox (XL2000 sr1 on W2K sp2)
Clear previously used cells! (Excel 2000 >)
always in txt format... (2000 sr 1)
Macro (MS Excel)
password applied in macro (excel97)
View data in sheet (2000)
Controlling Msgboxes (XP;SR2)
Excel Addins (Excel 2003)
lookup (?) (2000)
Saving One Sheet into a separate workbook (2000)
Custom AutoFilter (XP; SR2)
LOOP Counter (Excel 2000)
Incomplete Macro (Excel 2002)
Match Absolute Numbers (XP; SR2)
Selecting folder and reading file names (2000)
elminating duplicates (Office 2003 Windows XP)
Sheet Numbering (Excel 97)
reverse last name, first name (Office 2003, Windows XP)
Calculate result from other WS's (E2002)
VB Userform Timer (XP)
If Formula (Excel 2002)
COLORIZE LINE (2000 sr 1)
Userform (Excel 2000)
ComboBox with dynamic list (2000)
linked files in same directory (excel 2000 ver 9.0.3821 SR-1)
Phantom macro (2003)
Multiple print ranges (2003)
Pivot chart item (Excel 2000)
always in upper case... (2000 sr.1)
user name in the cell (2000 sr.1)
Userform gif (Excel 2000)
A Better Way (XP; SR2)
Wrong Subtotals (Excel 2002)
Screen resolution (Excel 2000)
Hiding Rows (2000)
Macro Disabled (2000)
Drop zero values in Pie Chart (Excel)
Clean up data (2003)
Extract and Replace Text (2003)
Macro to paste into different workbook (Excel 2003)
Data Validation (2003 SP1)
FIND DUPLICATE (2000 sr 1)
Copy Subtotal Rows (2003)
Format List in Data Validation (Excell 2002)
Move to cell after list selection! (Excel2000>)
Printing Comments (2000)
Inverted date... (2000 sr 1)
Formula Help (2000)
Name Manager Update (97, 2000,xp,2003)
Using xp templates in older versions (xp and lower)
Book for Excel 2003 (2003)
F1 doesn't bring up task pane (2003)
Help with formula (2003)
Excel XP - Dynamic Print Range (XP)
Count Characters (Excel 2000)
Extract Part Text from cell (Excell 2002)
SET EXTACLY THE SHEET (2000 sr 1)
#Value error (Excel 2000)
ActiveX Listbox does not save contents (Excel 10)
Help with a formula please (Office 2000)
same first line on all pages (2000 sp3)
Notification of workbook updated in Excel spreadsh (2000)
cell color (Excel 2003)
Naming multi-area selection (2k)
write and read on a closed wbook (2000 sr.1)
Variable # of data rows (Excel 97)
Secondary axis (Excel 2003 SP1)
Userform Textbox value (Excel 2000)
Message Box When Changing to another worksheet (Excel 2002)
Combobox Change event (2k)
data validation list source (Excel2000)
Number Display (Excel 97)
Extract first 2 numbers from MM/DD/YY data (Excel 2000)
Workbook list in Window menu (2000/SP3)
workbook_open & workbook calculation (XL97 and XL
Help Windows (2002 (XP))
Dialling from Excel (2002 (XP))
Decimal Alignment (2002 - SP2)
colum to rows (officexp 2002)
Number match (Excel 2000)
Percentage format (Excel 2002)
checkbox, and textbox (Excel 2000)
FILTRE AND PAST IN WORD (2000 sr 1)
guide of ADO (2000 sr 1)
Formula Help (2000)
Excel Macro (Excel XP)
(Impossible)Number Add to Find (Excel 2000)
VB edit not responding (Excel 2000 SP-3)
Look up/prevent duplicates in a column (2002)
Office Clipboard (XL 2003 SP1)
Wrong ISSEROR (Excell 2002)
Disable Smart Tags? (Excel XP >)
What are 'Label Ranges' for? (2002 SP3)
Pivot Table and Countif calculated field (2003)
Tracing external data links (2003)
Count If Like (Excel 2003)
Getting Around Password Protected Worksheet (Office 2003 Professional)
Narrow Name Box (Excel 2002)
Calculating Time (2002 SP3)
A spreadsheet's bottom right-hand corner (Excel 2000 and XP)
Print Multiple Worksheets (E2000)
Cell reference (Excel 2000)
e-mail different tabs in excel (excel 2000) (421835) was moved to the Outlook board
Incrementing a row value (97--->)
half kilo calculations (E2000)
Sum Query (Excel 2002)
combo box list fill range (2k)
formula auditing toolbar (office XP)
excel formula (office xp)
Inserting rows and AutoSum (Excel 2002 SP3)
How does it find the answer (Excel 2002)
Yet again..sorting problem (2000)
find second text string (excel 2003)
Excel Worksheets to Text (Excel 2000)
Freeze panes (2000)
Row height automatically adjusting (Excel 2000)
Uncorrupt a possible corrupt file?? (Quattro Pro?)
Comments in Excel (2000)
INVERT RANGE OF CELLS (2000 sr 1)
Radar Charts (2000/2003)
Requerying a form?? (2002)
combobox recycling event (2k)
copying row heights (Excel2000)
Text in formula (Excel 2000)
Cell Formatting (2000)
MACRO + ACCESS (2000 sr 1)
IF function with date as logical test (Excel 2000)
How old is Great Grandma? (Excel 2000)
Code only runs once (2000)
Creating list from sheets (2003)
sending mail (2003)
Formatting using Case Statement (Excel 97)
Filter by combobox (2000)
Macro for Row Inserts (2002)
IS NOT a word (Excel 2000)
Split full name into first and last (Excell 2000)
Forcing screen update? (2000/sp3)
optionbutton select case (2000)
Shortcut to Re-order list items (2000)
Displaying additional values on chart (2003)
axis alignment in chart (XP)
Protection ,,,, Shared (2003)
Using .find() without wrap around? (2000/sp3)
Selecting a random name (2003)
Using Macros for inserting Symbols (Office 2003)
Prompt for Delete Sheet (Excel 2003)
Cell Sizing (Excel 97)
adding custom buttons to worksheet (EXCEL 2000)
Shift Set of Cells On The Right... (2000 sr 1)
Combining Data (2002)
VLookup With LEFT Function (2002 SP3)
Customize Menus Question (Excel 2000)
Test for sheet name (2003)
Conditionally Select Formulas (Excel 2002)
Print Question (Excel 2002)
If OR statements (2000)
dynamic range name (2000)
selecting relative cell (2k)
Saving a workbook (Excel 2000)
Comments (Excel 2000)
Reinstall of Excel (XP)
Reverse calculation (MS Excel 2000 SP3)
repair workbook no more macros (officexp)
RE: Importing External Data (XP SP1)
Advanced filter criteria (Excel 2000)
F9 shows different answer than cell (2002)
linking (2000)
Each sheet in book (XL-97 +)
Sound on Re-Calc (Excel 2000)
Remove blank rows! (Excel 2000 >)
INSERT VALUE DURING THE MACRO (2000 sr 1)
Formula Problem (again, sorry) (E2000)
Plus sign (Excel xp)
Find Match and Insert Name (2000)
error FileSystemObject (2000 sr 1)
Dropping the lowest grade formula (Excel 2002)
Creating a database table from a summary table (Excel 2000 >)
3 Useful date calculations! (Excel 2000 >)
Shading alternate rows (Excel 2000 >)
Project Explorer Ghosts (2000, SP-3)
save as (2003)
Cell text in formula (Excel 2000)
Understanding an IF (XL2K SR1)
Hide/Unhide (2000)
Moving a Range (2000/2003)
Stephen Bullen (all)
Is this an Excel file? (2000/sp3)
Change Event (2002)
VB code/macro security settings and tabbing (Excel 2000)
Cannot assign macro to button (2003)
Long Report (Excel 2003)
particular request.... (2000 sr 1)
conditional format question (2003)
Filtering specific numbers (XP)
Finding Combinations (xp)
Notes on Forms (2000)
Formula / Hyperlink (Excel 2003)
Finding the Row Number after a VLOOKUP (Excel 2000)
Copy multiple worksheets (2000 & up)
FIND DUPLICATE (2000 sr 1)
Identify who runs a macro (Excel97)
How to disable automatic date change (Office XP)
Two files open at once (XP SP2)
Formula issues (XP)
ASAP Utilities new version (97+)
File Locked for Editing (Excel 2000/ W98SE)
xlCellTypeVisible (2k)
RE: Joining data for Graphing (XP SP1)
NETWORKDAYS not (net)working (97/2000/XL)
Custom Views (2000)
Drop lowest score and Weighted average (Excel 2003)
Userform - unload (Excel 2000)
Sorting Data (2000)
Sort protected sheets (2002, 2003)
Printing worksheets (E2000)
Can Excel do this (2003)
Earned Value Calculation (Excel XP)
ghost during the scroll... (2000 sr 1)
'running' an excel file from command prompt? (2000/sp3)
Simple questions (2002)
Whiteboard (Excel 2000)
Limit Number of Characters (2000)
Creating a new workbook in the background (2000/sp3)
Excel XP/DOS Lotus macros (XP)
Merge & Center (2003)
Column Colours (XP)
Convert Word Table Formulas? (Excel 2000+)
Formula (2003)
VB Toolbox -Toolbar (Excel 2000)
Validation Lists (Office 97)
Rows to repeat at Bottom (2000)
UserForm_Activate() event not in object browser (2000 SP3)
Time/Weeks (Excel 2003)
Frequency Plot (XP)
2 screen refresh issues (2000 sr1)
Saving Start-up Directory (Excel 2002 SP3)
single cell format within a range (2003)
Checkbox (2000)
Creating Worksheet Templates-A success (XL97 --->)
Recently usde file list (WinXP Of 2003)
Wrong date format (2000)
SELECT FILE FROM A LIST (2000 sr 1)
Cell Format (Excel 2000)
Variance (2002)
Workbook Variables (Excel 97)
save file (2000 sr 1)
If Statement (Excel 2000)
Formula Help (Excel XP)
Blank Cells (XP)
Format Date (Excel 97)
Change chart type with vba? (OFF2k/WinXP)
Data Vlookup will not read (Excel 2000)
Can't Edit Comments (2000+)
Shade Cell if specific text entered (Excel 97)
LOOKUP ISSUE (EXCEL 2000)
Remove VBA (Excel 2002)
'transpose' in Excel
9.0 Object Library (2003)
Need Formula (2000)
Object cannot be accessed in shared sheet (ExcelXP)
When is a blank cell not a blank cell? (2002 SP3)
Save as Greyed Out (Excell 2002)
STRING FORM TXT FILE... (2000 sr 1)
Excel Formula (Excel 2000)
Formatting? (Excel2000)