Windows Secrets
Windows Secrets Lounge
Function names in different language versions (Any
Checking data accuracy (2003)
Personal.xls problem (2003 sp2)
Best way to do a list (XP)
Defined functions (2002)
Excel Time Help (Excel 2003)
Graphing positive & negative (2K2)
Columns lost; can't get to (2003)
Counting question (2003)
vb crital icon and combined boolean (excel 00)
Clearing comboboxes on cancel (2000)
Max & Min (2000)
Hidden Row/Column Headers (1)
Closest match (Excel 2003)
networkdays (2000)
Cut and copy range... (2000 sr 1)
Userform controls -looping (2000)
Converting csv, keep values (Excel 2003)
Green arrows in Upper Left Corner of Cells (Excel 2003)
text to speech (Excel 2002)
Still on vlookup (2000 sr 1)
Sumif (2000)
Revisit: Error during pasting (Office 2003)
Control Toolbox Command button Control Tip Text (Excel XP)
Setting Transparency on a graphic (Excel 2000/2003)
Adding leading zero's (2003)
Cannot group that selection (2002 SP2)
Moving multimple colums into one row (Office XP SP3)
Data Query Refresh (03)
TRAPPING ERROR (2000 sr 1)
Extend Range name (Excel XP)
Protect Math In A Single Cell (2000)
sum based on matches (2002)
Using Find and Replace (200)
Copying and pasing multiple cells (2000)
Auto-insert amounts (Excel 2003)
Excel Sheet Tabs to Large (Excel 2003)
find unique include row above and below (excel2000+)
Chart update with new data (2003)
Header & Footer margins (2003 SP2)
Why not work... (2000 sr 1)
calculate only workday (2000 sr 1)
IF & MATCH (2003)
Searching Password Protected Worksheets (XP)
copying range with unknown number of sheets (excel 2003)
Modify Formula (2003)
lock sheets macro (excel 2000)
Excel start locations don't persist (2003)
Merged Cell Error Message (03)
Weird IF Structure (Excel 2003)
Delete Sheet in Shared WB (Excel 2003)
Macro to filter for specific files (excel 2003)
Excel VBA - horizontal time/date bars(as in Chart)
Complex If Problem (Excel 2000/2003)
Vlookup syntax problem (2002 SP2)
Count IF (03)
Macro to copy sheets (excel 2003)
Cell value change triggers event (Excel 2000)
Conditional formattinvia VBA (2003sp2)
WHAT is this textbox? (2003)
Negative Numbers (Excel 2000)
cell order change (excel 2003)
If Problem (Excel 2000)
Counting exact matches and mismatches (2000 SP3)
Not found in lookup... (2000 sr 1)
extract specified text from column (IE 5.5)
Formula Help (2000)
Can't break links (Excel 2003)
Sharepoint and Excel (Excel 2003)
Calculating Mileage (Excel 2003)
Progress Meter (Excel 2000/2003)
Customise top display caption (2003)
Special Cells Column Width (03)
fixed row height after paste (excel 2003)
Getting help... (Excel 2003)
paste web content to one cell (excel 2003)
Counting duplicates (Excel 2003)
Refresh worksheet (Excel 2000)
Turn-Off Action Buttons? (2003)
Calling up a Printers to choose from in a list box (Excel)
Printing out range of documents (2000)
Internal hyperlinks in VBA (Office 2003)
reference cells (2000 sr 1)
SUMIF Function Formula with Multiple Criteria (Excel XP)
intercept click on web page (2000 sr 1) (575152) was moved to the Web Design, Coding and Scripting board
Cannot save a shared workbook after inserting a ro (97 sr2)
Highlight changes to data (2003)
hidden columns & graphs (2003)
If (2002)
Manipulating EXCEL Data (WinXP - SP2; OXP)
Determine if Value or Formula (XL2002)
Cart Title Disappears (Excel 2003)
Array Formula - IF (2002)
Conditional Formatting (WIN XP/Excel2003)
ROMAN function (Excel All)
Extract Sheet Name From Formula (Office 2000-2003)
Rows not showing all of text (Excel 2002 SP3)
TYPE function (Excel all)
Charting (2002)
Custom Formatting (2000)
Object librarys (excel 2003)
Calculating sums in different spreadsheets (2003)
File Info (XL 2002)
trapping var (2000 sr-1)
Restrict Cell content length (2003)
Macro's (2003)
Analysis Tookpak (2003)
Conditional Format vs Interior ColorIndex (03)
add save date and time to a save name automaticall (excel 2003)
xlColorIndexNone (Excel2003)
Open without Read Only (Excel 2000)
Data Pilot - free add-on (97+)
Amending list in Data Validation List (2000)
React on external data dialog response (Excel 2003)
Freeze Panes and ScreenUpdating conflict (Excel 2003)
paste quotes into excel get removed (Excel XP SP3)
File path in Excel Title Bar. (2002)
list box formatting (2003)
Saving a format cell custom setting (Excel 2003)
Hide Rows (Excel 2000/2003)
Take list get single value making a new list (Excel 2003)
Custom formatting text (Excel 2003)
Variable not defined (Excel 2003)
Cell Contents in a Cell Reference (2002)
no delete line if contian 'AAAAA'... (2000 sr 1)
'Too many different cell formats' Error (Excel (All))
Delete Repeated Cells (2000)
Changing Name style (2003)
Footer (Excel 2003)
Linking multipage Excel on Word (Excel XP)
Path/File variables in link formulas? (Any)
list macro (Excel 2003)
Seach/Replace Help (2k/2003)
Txt data into Excel (2003)
Financial Planning - Efficient Frontier (Excel 2003)
Sharepoint and Excel (2002/2003)
Watermark/Bookmark (excel 2003)
Strip Averages (2000)
'SaveDate' function? (all)
using offset and match (Excel 2002)
show color in cell... (2000 sr 1)
LINK TO C:\ (2000 sr 1)
Excel calc wrong (excel - office 2003)
Save just a worksheet (excel 2003)
Calculate time elapsed #2 (Excel 2003)
Calculate time elapsed (Excel 2003)
File name as a variable in a formula (Excel 2003)
Making a Data file to export (Excel 2003)
Conditional transpose Colomn to Rows (2003)
Modeless Form (Excel 2000/2003)
Data Validation Problem (Excel 200)
Data Validation - Extending List (2003)
Value Y - axis Title not complete (2003)
how to speed up conn with mdb... (2000 sr-1)
Filters - automatically remove (2003 SP2)
Hiding Worksheet while VBA App runs (2003)
Protection and AllowFormatting (Excel 2000 and 2003)
Bug in Application.InputBox function (97, 2000,xp,2003)
Opening link in a new window (2002/2003)
Conditional formatting - weeknum (97)
Sum cells that includes text (2003)
opening an excel workbook and losing data err (excel 2003)
Copy & Paste based on Variable (Excel 2002)
Macro: find value and copy data (2003)
IF statement (Excel 2003)
Post-Format Worksheets To Text.. (WindowsXP - Office2003 Pro)
Macro to keep pair of number (Excel 2003)
Link to AutoFilter Settings (2003)
Hide & Password Protect Worksheet Based on User (Excel 2002)
Page Numbers (Excel 2003)
filter (2003)
on error bypassed (2003)
Setsourcedata - type mismatch (2003)
Excel shared workbook - views not being stored (Excel 2002)
Macro for list (2003)
Finding last row of a selection (Excel 2000 or 2003)
Combine worksheets? (2002/SP3)
Cell Format & Vlookup Problem (Excel 2002)
Copying formulas (2000)
Years between two dates
Creating Timesheets in Excel (Office X for Mac)
cell function (Excel 2000 SP3)
Autorecover (Excel 2003)
LINEST/Regression (2000)
Cell contents not updating (2000)
Format based on criteria (2003)
List box font Size (Excel 03)
Date format (Excel 2003)
Excel Drop Down Box (Excel 2000)
Name Manager Update (97, 2000,xp,2003)
Cell Formatting Question (Excel 2000)
segment a file (excel 2003)
Macro to Hide/Unhide Pivot Table Items from a list (Excel 2002)
Symbols in Plot Legend (2002 SP3)
Plot - No Gaps for Empty Cells (2002 SP3)
Scenarios (Excel 2000)
Reliability of Excel for Statistical Purposes? (XP or inferior)
text to row (excel 2003)
Need Formula for positions in string (Excel 2002 )
15 precision Points (2k and 2k3)
Need Formula for Points (Excel 2002 )
Icon for transfer (Excel 2000)
counting (Office 2003 SP2)
conditional format of Shapes (2003)
How to Force Recalculation (2002)
Lookup 'close' to next row (any)
Removing certain value points frm chart Data Serie (office 2003)
Excel Time Calculation Formula (2003)
MIN with 2 conditions (XL2000)
subtracting highlighted cells (2003)
Cleaning up Data (XL-2003)
Access Key on Form Button (Excel 2003)
Changing from Formula to Value (Office 2003)
Cannot Open Protected Workbook (2000+)
Group Radio Buttons (XP/SP2)
Tab Control in a Form (XP/SP2)
printing to pdf (XP Office2003)
Prevent workbook from closing (2000)
using a check box to add a sheet (excel 03)
Hiding Results (MSO 03)
Funny password problem (Excel 2003 Office XP SP2)
How to read a formula (Excel 2000)
Step -1 (03)
Compatibility Excel 2000/2003 (Excel 2000)
Array Element (03)
Opening Word from within Excel (2000)
Announcing: Name Manager 4.0 Beta (97, 2000,xp,2003)
PasteSpecialComments (XL 2002 SP3)
Cumulative Totals (2000)
VBA in Web Template (Excel 97 & 2003)
Conditional Formatting (2003 SP1)
Fill combobox.... (2000 sr 1)
Custom form(s) (Excel 2K/SR-1)
Custom Text In Numerical Format (2000)
HLookUp a range (2003)
found not fouond stop (2000 sr 1)
Pictures from Hyperlink (2002)
Crystal Xcelsius (2002 SP3)
Text in Freeze Pane (Excel 2003)
Import to web (Excel 2003) (569804) was moved to the Web Design, Coding and Scripting board
Excel 'database' (Excel 2003)
Interaction between userform controls (XL 2003 SP2)
Calculate (2003)
GO TO (Office 2003-SK1)
Excel Sound Alert (2002/2003)
ordinal formating? (Office 2003 SR2)
Columns as Numbers instead of Letters (Excel 2000 or 2003)
ASCII character (2003)
Merge Cells and Locked (2000 and 2003)
Pivot recalculate macro (Excel 2003)
VBA coding to go to cell not working (2000)
Conditional Format ? (Excel 2003)
Custom Add-In Problem on Network Servers (Excel 20
Upside down text (2002 SP3)
Negative to positive numbers (XP)
Vlookup Problem (Excel 2003)
MSQuery numeric range (xl97 )
Import Dynamic Range Names (Excel 2000>)
Hid Columns Based on a named Cell (Excel 2002)
Convert Text Numbers to Percentage (Excel 2000>)
Adding STDEV to the AutoCalculate Area (Excel l2000 or 2003)
Creating a hyperlink list of sheets (Excel 2000 or 2003)
Update Cells (2003)
Controll if in column are.... (2000 sr 1)
Formatting in Concatenated Cell (Office 2003)
Getting totals for time (2003)
Determine Pivot Table Source Data (2002)
Checkbox controll.. (2000 sr 1)
Automatically transferringm data from Access to Ex (2000)
Security Msg Hiding Offscreen (2002 sp3)
Sheet Limit??? (Excel 2000 or 2003)
dll and ocx not present... (2000 sr-1)
Weird Font Issue (Excel 2002 SP2)
Environ Function (XP)
Converting Text to Date (Excel 2002)
Properties Missing From ComboBox (Excel 2003)
GoTo (Excel 2003)
Automatically going to cell when spreadsheet opens (2000)
Autoselecting values (2000)
Quick way to get to bottom left of spreadsheet (2000)
Missing Discount (Excel 2002)
Order of calc. in a nested IF (Excel 2000>)
Curse of the werechart (Excel 2003)
VBA formulas (Excel 200 or 2003)
Changes between pivot table columns (Excel 2003)
pivottable totals (2000)
Identify Members of a Group (03) (568016) was moved to the VB / VBA board
drop down list (2000)
FInding missing links (2000, XP, 2003)
Change range in vlookup (2000 sr 1)
Pivot Tables and Calculated Fields (2003)
Context Menu Repair and another (XL2003)
Filtre data with user form... (2000 sr-1)
Mapping Customers (Office XP)
Text Box Centering (03)
Combine two spreadsheets based on matching column (2002)
Pivot Chart Question (2003)
Chart Data Range (2003)
Formatting dates (2003)
Macro to Divide Workbook into saved sub-workbooks
Enabling Macros??? (v. 2000)
Named Ranges in VBA (Excel 2000 or 2003)
How to breakin line... (2000 sr 1)
Number formatting (2003)
Copying and pasting multiple cells (2000)
Devide in wbook... (2000 sr 1)
Prompt for input (03)
update date/time in a cell only when macro is run (11.8012.6568/2003)
Delete a Link (2000)
What does this sub routine do? (2003)
Not equl value into sheet and mdb (2000 sr 1)
Exclude from row.... (2000 sr 1)
function or integrate code (2000 sr 1)
Updating Broken Hyperlinks (Office XP)
countif and AND (xl2003 sp2)
a loop for various named ranges (excel 03)
Tabs-Color Font or Fill? (2000)
Openfile macro (2003)
Text from 2 cell to 1 cell (2003)
Dividing a cell horizontally (Excel 03)
Data Validation and Deleting Rows (2002)
Leading spaces (2003 SP2)
Put value into 2 sheet simoultaniuos.. (2000 sr 1)
References (Office 11)
index of the current workbook (97)
cell location (2003)
Is this code ok for 2003 (2003 sp2)
Help with =IF statement (Excel 2003)
Printing Backgrounds (2003)
Printing formatted comments (2003)
Display comment only if author (Excel 2002)
Admission Lottery (stratified) (2003)
Conditional Format formula (Excel 2003 SP2)
Excel worksheet (2003)
Split a cell diagonally (Excel '03)
Titling a Spreadsheet (Excel '03)
Find the number location in a cell (2003 sp1)
MS Query debug (Excel 2003)
Lookup (2003)
Multiple Named Ranges (Excel 2000 or 2003)
VBA using Names in Vlookup Range Argument (Excel 2000 or 2003)
VBA and Right( ) functino (Excel 2000 and 2003)
Can a formula read US$1500 as a number? (2002-XP)
WBS Decimal Removal (2003)
Importing/Pasting a WORD document into a worksheet (HELP, Please (2000))
Summing a Pivot Table in an Excel macro (2003)
Prob on import txt.. (2000 sr 1)
IF statement locating text string (2002 SP-2)
Rounding integers to thousands (2000)
rename Names in formulas (Excel 2003)
Template help popup (Excel 2003)
Header (2003)
Change text to hyperlink (2003)
'Cleaning' a date entry (2003, 97)
VLOOKUP (XP / 2003)
Display rows - Even or Odd ONLY (Excel 2003)
on focsu textbox... (2000 sr 1)
don't open in new instance? (xl2003sp2)
Top 10 list (XP+)
What -- means in formula (Excel XP)
Macro HELP Please (2000)
Print Out Fill Effect in Graphic (Excel 2003)
File not saved (XL2000 SR-1)
Webpage folder (Excel 2003)
Compile Error (Excel 2000)
Avoiding Date format (Excel 2003)
Email Button Macro (2002)
Add Menu to XL Worksheet (Windows 2000 - XP)
Worksheets & Workbooks (MSO 03)
adox.catalog (2000) (564961) was moved to the Access board
Userform in template... (2000 sr 1)
Sum if Cell contains 20L (Excel 2002)
Rowsource for sheet combobox (2003)
Hyperlink to Excel Template (Excel 2003)
Multiple VLookup (??) (Excel 2003)
Excel Security (2003)
Userform destroied me! (2000 sr 1)
Open and formatting workbook (XP)
Sort a pivot chart (2003 SP2)
Fitting spreadsheet onto one page (2000)
HLookup or Match (XP)
vlookup querie (2003)
Macro help (2003)
A1!B10 won't yield November!B10. (2003 SP2)
Importing Excel WS as attachment (Excel XP)
Numbering lines (2000)
Copy comment (2003)
Printing Macro Help Needed (2000)
Cell References (Microsoft Excel 2003)
IF AND Help (2002)
Custom Format for email addressses (Excel 2003)
Protecting Specific Cells (2002)
Validation list link to different sheet (Excel 2002 SP3)
If statement that includes adjusting a number (Excel XP)
Only concatenate bold text (97, 2003)
Named Cells (XP)
Getting Captions (Excel 2003)
Quick and simple way to sort data (2000)
advanced filtering & obtaining unique items (Excel 2002 SP2)
stopping excel from copying (Excel 2002 SP2)
Author property (2000 and later)
Locating the source of the largest/smallest change
Subtracting Named Range (Excel XP)
Duplicating a spreadsheet entirely (Excel 2003)
Data Validation Drop down size (Excel 2003 SP2)
Complex Calculations in Cell (ExcelXP)
Excel color change (Excel 2003 SP2)
Check for open XLS (Excel XP SP-3)
Count and transfer data (Excel 2000)
Sorting columns (Excel 2000 SP3)
Automatically Generate A Backup File (XP-Office2003)
ASCII Change formatting (Excel 03)
bring up goal seek (excell 2003)
Turn off rounding (2003)
Numbering forms (Excel 2002)
Application false true.... (2000 sr 1)
No import dupes (2000 sr 1)
Format month-year (2000 sr 1)
VBA Beginner (2003)
limit possible values (Office 2003)
Resizing Charts (2000 SP3)
split dates from col to three (excel 2003)
Excel linking to Outlook Public Disribution list (2003)
Copying graph from one spreadsheet to another (200
PasteValue Problem (Excel 2002)
Countif on Multiple Worksheets (Excel 2000)
Finding duplicates (Excel 2003)
grouping (excel2003)
COUNTIF <> '' (2002 SP3)
Filter list by 1st few chars (2003 sp1)
Copying sheet without changing references/formulas (2000 SP3)
Excel - Sorting (VErsion 97)
-- or 1* or ?? (any)
inested name of sheet... (2000 sr 1)
Monthly increments on x-axis (2000)
Multipication of cells by same number (2000)
Changing a Pivot Tbl with vba (2000)
Array Formula - Value Check (2002)
Two if statements in one formula (XP & 2003)
Extract numbers from a cell comment... (XL2003)
Error when run macro (2000)
Quck way to insert multiple blank rows (2000)
ISERROR ?? (Excel 2002)
Duplication of data ranges in other worksheets (2000)
Generic undo routine for vba (part 2) (2000, XP, 2003)
Vlookup with true setting (Excel XP)
Open Excel in new window (2000sp3)
Lease Calculation (Exel 2000 sr1)
Date Sorting (Excel 2000 (9.0.6926 SP-3))
Creative Sorting (Excel 97 & higher)
timer add in? (2000)
HMS time data conversion (2000)
What causes this virus warning (XL 2003)
list box with autocomplete (excel 2003)
Sums or counts cellsbased on specified fill color (2003)
populate empty cell if condition is true (XL2000 s
Add totale and trasfering in other sheet.... (2000 sr 1)
Text to Dates (2003)
List for three cells (2003 )
Text in cell to undescore (2003)
return last entered value (excel 2003)
trend curve formula (2000 SP3)
0 value (Excel 2003)
Loosing Formula References (Excel 2003 SP2)
Creating linked formula prob (2002)
Tornado Diagram Add-In (2K +)
count (2000)
Extend row source (2000 sr 1)
copying spreadsheets to new book (2003)
de-concatenate (excel-2003)
Statistical Sampling (2002 SP3)
Moving data to Excel from Word (Excel 2003)
Value# error (2000)
Averaging across worksheets (97 SR2)
Simple financial formulas? (2003, 97, XP)
String blank, WHY! (2000 sr 1)
word document in excel (excel)
Adding Totals to a stack chart (Excel 2000>)
2 week email notice of off-day! (Excel 2000>)
Filter for non zero calc over rows (Excel 2000>)
Strickthrough text (2003)
Drive Mapping (03)
Stop excel plotting zero values? (Excel 2003)
Class Frame Click event (Excel 2003)
Error on exit (Excel 2002)
shifting from absolute to relative formulas (Excel 2003)
Cell Formatting - Text (2003)
Lookup? (2002)
Command Bars (Tool Bars) (XL2003)
Excel forces save at close (Excel 2002, SP-1 on Windows XP)
Inserting row in sheet (2003)
Tracked changes (Excel 2002)
Hide All Comments On All Sheets... (XP-PRO OFFICE-2003)
copy from dir to other dir (2000 r-1)
Value Error (Excel XP)
Graph Goals (2003)
ISERROR ?? (Excel 2002)