Windows Secrets
Windows Secrets Lounge
Extract Month from Date (Office 2003)
clear cell, but leave formula (xp)
Speaking lists (2000 SP3)
Formatting dates in footer (Windows, Excel XP)
vlookup and match (xp)
CALL DATA (EXCEL 2003)
Store Results in Specific Cells (Excel 2003)
Excluding Data (03)
Conditional sum (Excel 2003)
Limit (2003)
Insufficient memory (2004)
Best Way For Excel To Compute Ownersips (2003)
True/False Statements (Excel XP)
Lock Toolbars ? (Excel XP)
Histogram issue (2003)
Working backwards to calulate a date (Excel 2003)
IF(and conditional format (2000/2003)
Restricting Cell Input (2000/2003)
Lost autoclose of blank document (11/2003 SP2)
Quirk with VLOOKUP (2003 SP2)
Find pivot chart data (2003)
Vlokup with 2 value in 2 different column (2000 s
Including cell references in VBA code (2003)
Paste cell into Text Box (Excel 2002/2003)
Use vb to Sum value in column (2003)
looking for a way to update a file... (2003)
Themes (2007)
file 10,000 kb problem (2000)
protecting conditional formatting (2002)
Pivot Table Field Not Updating Properly (03)
Add-in path difficulties (2003)
Report/Data Exchg Access/Excel (Office 2003)
Extracting a graph from a table (2k7)
Tip: percentages with spinners etc (Excel 2002)
Charting dissimilar data types (2003)
For next back (2000 sr 1)
automatically updating links (2003)
Add croll bars to Comments or Callout Boxes (XP / 2003)
Copying cell links in spinners 'relatively'? (2002 )
Graph Data smoothing (Excel)
Calculating dates and the passage of time (Excel 2003)
cicling item not present (2000 sr 1)
Macro to move information and delete rows (2002)
Sheet tabs (EXCEL 2007)
Advance functions (Excel 2003)
Help intepreting an array formula please (2002)
Get Data From Worksheet on Drive (2000/2003)
PLEASE HELP! Sorting adds extra pages (Excel 2003/SP2)
Hexadecimal Sorting (2003/11.8134.8132 SP2)
Excel Macro (2003)
TABLE function in array formula -- help decipher p (Excel 2002)
Count Specific Occurrence (2003)
Strange mouse pointer (Office 2000)
Count If Multiple Criteria (Excel 2003)
macro to email a pivot table (MS Excel 2003)
Form in Excel ? (2003/SP2)
Multiple Macros (excel2003)
If, contains (2003 (SP2))
multi replace with 2 character (2000 sr-1)
Combining Data in a sheet (Office Excel 2003 sp2)
Excel Module (All)
Dynamic Range Names (XP)
Newbie (excel 2003)
Run a Excel module from ASP.NET (2003)
XML Scenarios (Excel 2003/SP2)
IF(AND(Problem? (Excel 2002/2003/2007)
Find the last entry (2003)
Running a Private Sub on a UserForm (XP)
SUMPRODUCT PROBLEM (XL2K SR1)
IF and VLOOKUP formula (Excel 2002)
Sort IP address list (XP/2002)
fired, with deletetion line (2000 sr-1)
Data Validation % (Excel 2002/2003)
Macro (Excel2000)
Long formulas with linked cells (Excel 2003)
Share code (2003)
Combining Totals (Office 2000-2003)
More on Define Name (Excel XP)
Toolbar button for 'Define Name' (Excel XP)
vlook up problem (excel 2000)
Path to ActiveWorkbook.FullName (03)
Screen Corruption (2007)
hide rows if background colored (XP / 2003)
if function
Creating a list of Tab names (2003)
Insert formulas (2007)
Excel formula (2003 Service pak2)
Importing Database Query (Excel 2003)
Floating buttons (Excel XP)
Comparing data in columns (2003)
Conditional Formatting (XL2003 SP2)
Simple macro for Checkbox info (2003)
Split text in to columns (2003)
Disable Tools/Options (Excel 2002/2003/2007)
Lost Personal.xls (2003)
1 Button 2 Actions ? (Excel 2002/2003)
error bars and standard deviation (2003)
what if formula problem (excel 2000)
linking to access for a cell (2003)
Code to insert rows and sum (xppro ms2003)
Syntax for If statement and Checkboxes (2003)
File existance testing (2003)
Excel Filelocking Failure (Excel 2000 SP3)
Chart macro error (2002)
Excel string function (2000 upwards)
Limitations with MSForms.ComboBox (XP SP3)
Paste stopped working (2002)
Combined characters (Excel 2003)
Command buttons (2003)
year date format (2000 sr-1)
Total group of worksheets (2003)
Count on autofilter (2003)
open excel and word (2000)
Cells populated based on initial selection in List (2003 sp2)
Moving a character (2003)
SQL server connections (2003)
Data Validation % ? (Excel 2002/2003/2007)
Pivot Table Axis Order (Excel 2003)
sumif with cell value as criterion (2003)
Excel Charts (2007)
Tranfer data according to status con: (Excel 2002/2004)
3-D Columns (Excel 2003)
Failure of PivotSelection Property (Excel 9, 10 &
displaying input box to hide sheet (2003)
Delete VBAProject from Workbook (2003 SP2)
Spell check - protected worksheet (2003)
Put a small square in a cell (2003)
e mail (2000)
Source data for Pivot tables/charts (Excel 2003)
stupid qstion to ordering filed sin table (2000 sr 1)
Input masks for dates (Excel 2003)
Array Issues/sorting (2003)
sheet functions (2000)
Set print area dinamiclly... (2000 sr-1)
upper case only & validation (2003)
Getting Data from External file (Excel 2002 - 2)
find name of filed and insert value from sheet (2000 sr-1)
Password to Run Macro (Office 2000-2003)
Need to automate summing numbers in an range of da (Excel 2003 SP)
Counting cells with any value in a range (2003)
Dynamic Chart Range (2003 SP2)
Count with multiple criteria (2002)
countif with criteria range (excel 2000)
MS Excel Workbook Formula Copy (Excel 2003)
Combining formula and conditional formatting (Excel 2003)
combo box missing list items (xp xcel 2003)
Help needed with lookup formula (2003)
Calcing worksheet with filter (Excep 2003 )
Lookup Problem (2003)
Delete record based index... (2000 sr-1)
Convert from wb2 to xls (Excel 2003)
Concatenate Values (Office 2000-2003)
set range dinamiclly (2000 sr-1)
How to detect a template (2000 SP3)
Match or Vlookup or Index (2003)
XML Files (Excel 2003)
Change in Shared Workbooks (2003)
Look up moving data to cell with look up. (2003)
Last Saved date in cell (Excel 2002/2003)
Hidding rows based on value of cell (2003)
Cracking Worksheet / Workbook Passowrds in Excel (Excel )
Bold Text in Message Box (03)
VBA - Move Down (XL2003)
Importing (Excel VBA 2003)
Transfer data according to status? (Excel 2002/2003)
Pivot Drill-down for single subtotal (v2003)
Setting up X axis in months Chart (Excel 2000)
Vlookup cell location (Excel 2000)
Forecast Value for FY07 (XLS 2003 SP2)
hidding sheets all but one (2003)
Extract time (2003 (SP2))
Rounding hours (all)
Personal workbook (Excel 2003)
Automatically changing the color of text in cell (
Excel add-ins using own menus, toolbars won't work (Excel 2002 SP3)
multipassword (excel2003)
Vlookup Fails (v2k)
Update table in mdb (2000 sr-1)
Excel workbooks dont open as before (2007)
Link Cells -- Keep Source Cell's Formatting (2002 SP3)
Copy and Move sheet holding over 256 characters (Excel 2003 or 2000)
Print File Properties (2000 (?all?))
File opening (2003)
Check Mark (03)
Accessing data in drop-down menus (EXcel 2003)
Print from Excel (97 SR 2)
adding columns and data from other cells (2003)
Adding command buttons to Pivot charts (Excel 2003)
Struggling with IF function again. (Excel 2002/2003)
Macro - Worksheet Deactivate (Excel 2002)
Password Protect individual worksheets in File (Excel 2003)
Sort of Lookup... (Win XP pro SP2, XL2003 UK)
List (2002)
Macro - Sheet Name (Excel 2002)
Minimum of a Date (all)
MS Query source folder (2003)
batch xml 2 xls (2003)
Multi user macro (2003)
Sumif with formula as criteria (Excel 2003/SP2)
Hrs:Min Excel 2000 (2000 (9.0.6926 SP-3))
Add items to Listbox (Excel2000)
count functions (2000)
Pivot calculation (2003 (SP2))
function for time... (2000 sr-1)
date select (2000 sr-1)
Select Left Text to space (2003)
Using last entry in column (2003)
Double-Click Action (Excel 2003)
Remove Pattern from Shaperanges (2003)
New database query (2003)
Need a formula? (Excel 2003)
Searching through sheets - VBA (2003 SP2)
Dynamic chart (2002)
errror in selection copy (2000 sr-1)
Problem with dynamic chart (2003 SP2)
CSV Regional Settings (Excel 2003 +)
Data Validation on Text Boxes in VB Forms (2003)
Arrays vs. If Statement (Excel 2002)
Simplifying a Formula (2003)
Counting mins (2003)
Count.... (2003 SP2)
SUMIF & Concatenate (Excel 2002)
Lost Hyperlinks (2003)
Hyperlink to other sheets same workbook (2002)
COUNTIF with AND condition (2003)
Rotate Spinner? (Excel 2003)
annoying insert options icon (2003)
Read contents wihout opening (Excel 2003 / VBA)
Custom range in formula (2000)
special count formula (excel2003)
automatic comment (Excel 2000)
Validation list (XP)
Hide and password group of cells (2003/SP2)
Update Links Automatically (2007)
Represent Data in Chart Format (Excel 2003)
Performance of Indirect (Excel 2003)
Counts of words occurring (Excel 2003)
Counting rows (Excel 2003)
Pivot Table-YTD (Excel 2002)
OFFSET (2003)
What happened?? (Excel 2003)
Consistent colors for Bar charts (Excel 2003)
Max file size? (2003 SP2)
Index & Match ? (Excel 2002/2003)
Resize Excel Workbook (Excel 2003)
combinations of data (2003)
Find a cell meeting these conditions (Excel 2000)
Csv file macro (2003)
populate comun with unique item (2000 sr-1)
Convert date format (2003)
How to set the default Excel version (All)
Bell Curve on Graph (2003)
Macro to Select (Excel 2003 SP2)
Select Crop Tool with VBA (XL 2000)
Column Chart (2003)
New line Macro (Office 2000)
Filling in a form (Office 2000)
Copying Subtotal Results (Office 2003)
Date/day format (Excel 2003)
on error bypassed (2003 SP2)
MsgBox Problem (Excel 2002/2003)
Need Help for FV and XIRR (2003)
Excel Linking (2003)
Text To Date Formatting (2003)
2 column combo box (2002)
Text fields using the import wizard (Excel 2003)
Protect Worksheet (2002)
Date problem (2003)
subdirectory open macro (2003)
VBA open template (2003 SP2)
Counting two values (2003)
Dynamic Range and CountA (03)
Set with Select Case (03)
Header Based on Cell Entry (2003)
Developing Application using Oldest Excel Version (Excel 2000)
Run macros (2003 SP2)
ForNext Loop (2000)
Chart/Trend/Growth help (2000/2003)
count/sum array formula (excel2003)
Search with Match and Index (2002/2003)
formula help (excel2003)
Lookup for multiple lists (2003)
VBA Max of a column (2000)
Shift objects error msg (2003)
Problem accessing Series properties (2000/2003)
VBA UDF question (xl2k sr1)
Time Formula Problem (2003)
not refreshing data from network drive (2003)
Formatting (XP)
Linking to Pictures in Excel (Office 2003)
user name says default when opening an excel file (2003)
Look for item in a list (Excel 2002)
Convert Excel to PDF
Organizing worksheet tabs (Excel 2003)
Links not updating (Excel 2003 sp2)
As string to text (2000 sr-1)
Excel VB Error (Office 2002)
Data Validation list width? (Excel 2002/2003)
Trim-Parse troubleshoot (2003)
best fit page print (XL 2000)
Count Question (Excel 2003 ver 11.8117.8122 SP@)
Order of moving in a form (2003)
space of signle dir on a server dir (2000 sr-1)
Saving a workbook (2003 sp2)
Create Macro to Display a 0 not 0.00 in all Cells (2000)
SAVE AS ... (2000 sr-1)
MS Query source folder (2003 SP2)
Macro Code for Workbook the macro resides in (Excel 2002)
Average cells from multiple sheets (excel2000)
Using Charts as a Thermometer (Excel 2000)
Macro to Open Worksheet (Excel 2002)
Validation (2003)
min/max reference (2003)
Box and whiskers (2003)
Call Code (2003 SP2)
Chart options (2003 SP2)
Sony TFT Monitor Not Detected (Business) (641953) was moved to the Windows Vista board
Extract Associated data (2000/2003)
path/file access error when copying worksheet (2003)
Preserving format changes in Pivot charts (Excel 2003)
text in cells (Excel 2003)
Sort (XP)
Why not send sheet? (2000 sr-1)
Using same workbook with multiple Excel versions (2002 and 2003)
Print Preview View (XP professional)
* trailing a number (2003)
randon number (2003)
Elapsed Time (2000 SP-3)
charts (2003)
Conditional Locking of Cells (2003)
Deleting rows: another question (Excel 2003 on XP)
Comparing Columns (2003)
Reference a checkbox control (Excel2000)
Formula to be modified (Excel 2003)
Reference In User Defined Function (XP)
Isomonth (all versions)
Disallow Changing of Worksheet Name (Excel 2002)
Vlookup in Macro (Excel 2002)
print problem (2003)
Macro that Reads Table logic (Excel 2000)
many sheets into one (XP 2003)
Making a Data Grid (2002)
Count rows (Excel 2003)
Value not found in lookup... (2000 sr-1)
Dynamic Sheet Offset function (Excel 00)
Formula to Copy/Move Text (Excel 2003)
Code for checkbox function (Excel 2000)
Picking up information in row (excel 2003)
copy and paste sheet name (XP 2003)
Sorting strings in reverse order (Any)
Formulas (2003)
Format a concatenated string (O2003 pro UK SP2)
copy without button.. (2000 sr-1)
Remove Year from the Date (Excel 2003)
Book on Excel (Excel 2003)
Odd Solver Behavior (Excel 2003)
Timesheet that subtracts lunch hours? (2000)
Excel Formula (2003)
Vlookup with caption button (2)
Printing (not) (Excel 2003 on XP SP2)
Cut and paste objects with cells (Excel 2003 SP2)
Return 0 for all Negative Numbers (Excel 2003 SR2)
Chart Title (XL 2000)
Collate x's Problem (Excel 2002/2003)
Count Occurence (2003)
Watermark (Excel 2003)
Seperate Strings (2003)
Conditional Print (Excel 2002, SP3)
pivotcache fun (Excel 2003)
Manipulate Text (Excel 2003)
Combine Data for Pivot Table (2003 sp2)
sumif (2003)
MacroTroubles (2000/2003)
Count Products (Excel 2002/2003)
Macro-Copy & Paste at end of selection (Excel 2002)
SUMIF in Macro (Excel 2002)
Multi line records (2003)
Convert String to Formula (XP SP3)
Cable Sizes_Electrical (2002/2003)
Sum unique (2003)
autocreate trimestral datee (2000 sr-1)
Number of Characters (Excel 2002)
truncate data (2003 sp2)
Excel Upload into AS400 (Excel 2002)
Importing to access (Excel 2003)
rapidly remove 'merge and center'? (2003)
Find and matchcase (Excel 2003 SP1)
Copy ColumnWidth (2000 sr-1)
Hyperlinks to .jpg files (Excel 2002)
Append Change event code ? (Excel 2002/2003)
Timesheet calculations (2002)
Remove subtotal in pivot tbl (Excel 2003 / SP2)
Import data from note pad file thats > 65536 rows (Excel 2000)
Show All Data (Excel 2003)
Windows Dbl-click Open a new copy of XL (XL 2000 / Win XP Pro)
Randomize (2K3)
'Searching' or 'Lookup' formula (Excel 2003)
Excel number formatting trick (2000 sr1)
Calculate center of a triangle (XL 2003)
Sheet Focus (Excel 2003)
Saving an open worksheet (Office XP)
Linking Question (Excel 2003 SP1)
Auto Select by Mouse (Excel 2003)
Where's the Control Toolbox (Excel 2007)
Run a Private Sub (03)
Mistaken Identifiers: Gene name errors (Excel 2003)
Three dimensional chart (2002)
Comparing data in chart (2003)
Row heights (2003)
conditional summing (2003 sp2)
ODBC drivers -Excel (2003 SP2)
convert numeric values to dates (2003)
Tabstrip select (2000 sr-1)
Use a Calendar (2002)
need assistance.. (Excel 2000)
Import from Access (2003)
Webmail (Office 2003)
Run a macro with in a Macro (Excel 2000)
Months in Advance ? (Excel 2002/2003)
Dropping Columns (Excel 2000)
Deleting Rows (2003)
False.xls (Excel 2002 SP3)
Import Data into Excel (Excel 2002)
Excel Formula in Macro (Excel 2002)
Can a user suspend and resume macro execution? (2003 SP2)
Replacing lable character (Excel 2003)
Save Date (Excel 2003)
VBA Commands (2003)
Formatting Problem??? (2003)
Protecting/Unprotecting Multiple Sheets (2003)
Pivot or consolidate (XP)
Conditional Fontsize to next column (2003)
count sheets and cicling it (2000 sr -1)
Help with Formula please (Excel 2002/2003)
Need a 'search and count' formula (Excel 2003)
If, Then, Else (2000)
FORMULA BAR and FULL SCREEN (2007)
Sheet tabs (2007)
Re-order a 4 digit number (2K3)
Count sheets between sheets (2002)
count formula (2003)
Array Formula (2002 SP3)
Network Days (XP)
VBA Copy Last 30 Days - Paste Elsewhere (2003-SP2)
Variable Printing in VBA (2003)
Use of Solver.xla through VBA (Excel 2003)
Apply formula to filtered data (2003)
Negative Percentages (Excel 2003)
fill handle shortcut? (excel 2003)
File open dialog box (2003)
European 'WeekNm' (2003 (SP2))
Discontinuing footnotes (2003)
Advanced Charting 2 y axis with text scale (Excel 2000)
Right-click menu running code twice (Excel 2003 SP1)
Bad SP2 for XP download (XP) (636949) was moved to the General MS Office Suite board
Double Trouble (Excel 2002/2003)
Auto Correct? (2003)
Making a chart (2003)
AutoFilter (2003)
Calculating percentages (Excel 2003)
Mathematics behind Percentage Calculation (2002/XP)
Using VBA to Eliminate Rows (2003)
Excel VBA Challenge (Excel 2003/)
compare (excel 2003)
Excel Macro (Excel 2002)
Run Access Report From Within Excel (03)
Prompt to Delete Sheet (03)
2nd Highest Value In A Non-Contiguous Range (XP)
Insert a Word Document (2003)
Cell Formatting (2003)
multiple sheets extract (2003)
Chart (Excel 2000) (636699) was moved to the Powerpoint board
Code confusion? (Excel 2002/2003)
Copy only visible cells (2000 sr-1)
Formula Troubles (Excel 2003/SP2)
intersection of cells... (2000 sr-1)
Prevent data entry when macros are disabled (2003)
Excel Charting (Version 2003)
Excel Charts & Clear Type (2003)
Skip Change Event (2003)
intersect value and insert Total (2000 sr-1)
#VALUE! to be replaced (97)
Excel weirdness (2003 SP2)
VBA Equivalent (03)
Converting CSV to OFX format (all)
Counting Dates that Occur in a Particular Year (2003)
Excel Right Click Menu (XP w/Excel 2003)
dim number (2000 sr-1)
Excel macro to read from MS Project (Excel 2002/sp3, Project 2003)
Why this macro not delete the correct line.... (2
Search or Some Other Worksheet Function (03)
PivotTable cache (XL 2003)
Native Saving (2003)
Cicling FOR NEXT (2000 sr -1)
IF statement for text entry (2003 sp2)
calculate time of macro (2000 sr-1)
Error Deleting (Excel 2003/SP2)
Worksheet_Change Cleanup (2003)
& sign (03)
Breakout data (2003)