Windows Secrets
Windows Secrets Lounge
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)
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)
Sorts and Filters (Excel '07)
set range instead filter criteria.... (2000 sr-1)
Combine Sheets for simultanious input (Excel 2003)
Conditional formatting (2003)
Excel Charts 2007/2003 (Excel 2007/12.0.4518.1014)
MSQuery and dynamic names (All?)
Search for sheet name (winXP, office 2003)
Code Problem (Excel 2002/2003)
Chart (Excel 2000)
Data Validation Weirdness (Excel 2003/SP2)
Running Code from Another Workbook (03)
What is this in my spreadsheet? (Excel 2003)
Count lnes after filetr (2000 sr -1)
Does this make sense? (Excel 2002/2003)
Time limit access to workbook (Excel 2003)
Formula Suggestion (03)
Subtotal issues (XP & 2003)
count by quarter based on start/end dates (2003 SP1)
UDF Problem (Excel 2003, SP2)
Bigger Chart Boxes (2003 - sp2)
Formula (Excel 2003 Professional)
Collapsing rows with certain criteria macro (Office 2003)
Help with Error message ? (Excel 2002/2003)
use filter on a protected sheet (2000 sr 1)
Year (all)
Min % Increment (Excel 2003)
Comments Question (Excel 2002/2003)
IF 'YES' lookup a cell value in another worksheet
Disallow blank entries in cell (Excel XP)
formula help (excel2003)
Lookup Cheapest (Excel XP)
Strange Color Changes (3)
Create XML from tables (Excel 2003 Pro)
Formulas (Excel 2003 Professional)
Formula (2003 Professional)
Transpose column info (2003)
vlookup (all)
dim and set (2000 sr-1)
Switching Axes (Excel 2000)
Data/Text-to-Columns Equivalent Function (MS/Excel
format (excel 2003)
Scrolling (Excel 2003)
Sort items in combobox (2000 sr-1)
send excel info to access using an array (2003)
Cells not formating (2003sp2)
Compare in same Col (2003 sp2)
Specifying a User Name in Path to Import Data from (Excel 2003)
Copying attributes as well as contents (Excel 2000 SP3)
Shorten Formula ? (Excel 2002/2003)
Very Strange Formula Error (2003)
Export to Word (XL2003)
Set Range (2003sp2)
Formula to access data on sheet named in Col A (Excel 2003 SP2)
View Multiple Sheets in Workbook (Excel 2000)
Find second character (Excel 2003)
complex sorting (2003)
image in footer (2000)
Insert Worksheet problem (Excel 2003)
Extracting info using formula (2002)
Data Validation Question (2003 sp2)
Ffiter not work!!! (2000 sr 1)
AutoExecNew and DistMon (2002)
List Box to select multiple columns (2003 sp2)
Highlight Row (2003)
enable/disable Macro's (2003 sp2)
Protecting Cells (2003 sp2)
Conditional Formatting (excel 2000)
Header row on import (2003)
Changing Text of Textbox (03)
Status Bar length (Excel 2003/SP2)
Macro Help (2003)
Suppress 'Toolbar Options' on custom toolbar (2002+)
Track changes in a spreadsheet macro (Excel 2003)
Open files in a folder (Excel 2003)
Column Cells Value Scanning Using VBA (2003)
Conditional Formatting of Text (Excel 2003 )
MouseMove ? (Excel 2002/2003)
Setting up an option button (2003)
Call procedure should remember variable contents (2003)
Prob when i click on .xls file (2)
Mouse Over & Beep (03)
Sort in a locked spreadsheet (2003)
getpivotdata EXCEL 2000 (Excel 2000)
Sine to Angle (Excel XP)
Sum Function Key Strokes (Excel 2003 SP2)
part of string in Select case (2000 sr -1)
Improv-like Feature (XL2003)
Monthly repayments (2K3)
format/number/Text (03 SP2 )
Cascade Data (2000)
Excel Template (Excel 2003 / 2000)
Forms (Excel 2002)
Test For Cell Formula (03)
Mark Up Formula (Excel '07)
Group by PT issue (Excel 2003)
calculate day back... (2000 sr -1)
Aligning controls on Userforms (Excel 2003 SP2)
Output Worksheet Problem (Excel 2002/2003)
dates difference (excel2003)
vlookup problem (excel 2000)
Convert GMT to PST for classes (XP)
Copy of Histogram Loses Color (Excel 2003/WinXP SP2)
Macro-Search Data for 'Like' items (Excel 2002)
'With' Challenged (03)
VLookup in VBA (03)
Formulas (2003)
Auto set days of the week (Excel 2003)
'Paragraph' Formatting Within Cells (2003)
Disable Enter new worksheet? (Excel 2002/2003)
Workbook not visible (OXP)
Counting the numbers of columns that have data (Excel 2003 sP2)
Sort within a number (Excel 2003)
retrieving web based data (03')
RE: Cell Links to Data Sources (2003 SP2)
Find Dupes in a sheet (Excel 2003)
Message depending of day (XP)
How many people schedule each half hour (2003)
Macros disabled (2002 SP3)
eXclusive ORing (any)
set value of entire Range (2003 sp2)
Match email addressed (Excel 2003)
Remove comma from string (xp)
Interest calculation on theft/repayment amounts (Excel 2003/SP2)
Run Away Code (03)
Inserting rows and keeping formulas (Excel 2000 SP3)
conditional formatting (2002 SP3)
count in two columns (2K3)
Drive Word template from Excel (2003)
No option to save as XLT (MS Excel 2000 SP3)
Black-Scholes (97 +)
List of Range Names in Workbook (03)
MAX and conditional formatting (2002)
open XLMS doc in 2007 (2007)
'Options' missing from Tools menu (XP)
Data Form out of view (2000 - 9.03821)
Registry entry (2003)
Using Sumproduct with FIND function (Excel 2003)
ignoring all functions while macro is runnig (Excel 2000)
Formula Assistance Using SumProduct (03)
Cut/Paste Help (2003 sp2)
Delete line if...SUMM IS=0 (2000 sr 1)
Excel Autofill (Offoce 2003/SP2)
UDF - Remove characters
Counting on date and code (2003)
Excel Sumif Help (Excel 2003)
Is it possible? (MS Excel 2000 SP3)
Hide contents of entire worksheet (Excel 2003)
Pick from drop down list (Excel 2003)
Use of GetSaveAsFilename causes error in 2007 (2007)
MS Query Criteria (2003 sp2)
Possible causes of this error (2000 sr -1)
VLOOKUP (2002 SP-3)
need quick conditional format equations (2002)
Retaining Tooltips (2003)
delete blank space in records... (2000 sr 1)
ambiguous name detected (Excel 2002/2003)
Pivot add field error (Excel 2003)
Count formula not working (XP)
countif (2003)
Beginner Marco (Excel 2003)
Looking up specific results from a table (Excel 20
Open linked documents (Excel 2003)
Auto Calculation settings (2003)
Subtotal Reporting (03)
Parallel processing (2003)
New version of AutoSafe add-in (97 and up)
New version of VBA Code Cleaner add-in (2000 and up)
error trapping (2003)
Transpose macro (2003)
Printing protection (2003)
Text and Date in same cell? (Excel 2002/2003)
Volatile function problems (Excel2003)
Changing percentages (2003)
MRU Option greyed out (2003)
Crosstab Query and Changing Data (E2K, SP-3)
Paste Prompt (03)
countif with 2 criteria (2003)
XML Export = I M Stoopid (2003)
Restore Toolbar if User cancels Close File (2000)
export from Access to Excel (2003)
Using Macros to format a pivot table (2003 SP2)
Saving as HTML (2003 SP2)
Filer with 3 criteria (2000 sr 1)
Form Terminate Event (Excel 2000 SP3)
peraphs i am stupid vlookup erro (2000 sr 1)
Excel/Access automation (Excel 2003 SP2)
Copy/Paste Issue (2003 sp2)
Workbook_Open in Personal.xls (2003)
Cell format (2003)
Dynamic Range and Array Formula (Excel 2003 SP2)
ANALYS32.XLL cannot be accessed (Excel 2003 SP-1)
Lost the preciuos Hans's routine.. to know if file (2000 sr 1)
comment box (xp2003 sp2)
Resizing Selection (03)
Summary Sheet (Excel 2003/SP2)
Find next column on Row (2003/SP2)
Automating a Calendar (Excel 2003)
how to found the first occure
Persistent Link (2003)
Formula Question (2000 & 2003)
custom lists - non-contiguous (97-2007)
Code will not work? (Excel 2003)
msg box with 3 option (2000 sr-1)
Assistance needed (03)
Format changes with paste (Excel 2000)
FollowHyperlink uses Win Explorer in Error (XP Excel 2003)
Back calculation (MS Excel 2000 SP3)
Calculations work but cell shows '-' (Excel 2003)
Pivot Table from Multiple columns (2003)
sumproduct (Excel 2000)
File Menu Items Greyed Out (2003)
LookUp (Excel 2003)
Book marks in Excel? (2000 - 2007)
time sheet (2000)
possible to colorize items.. (2000 sr-1)
mouse over in vba for excel... (2000 sr -1)
Lookup quandry (Excel 2002/2003)
Adding th, st, rd to date (2003)
Hide Button Code ? (Excel 2002/2003)
VLOOLUP Returns #N/A (Excel 2002)
Pivot table count (2003 sp2)
very large comnbobox (2000 sr -1)
Resizing column selection (Excel 2002)
Agreement of day and date (MS Excel 2000 SP3)
Email Message in Excel (Excel 2003)
cascaded validation lists - very dynamic (Ex2003)
Breaking Links between Workbooks (2000 SR-1)
Positioning within a 3D Plot (2003)
Entering numbers to get names (Office 2000)
Using Name range defined in seperate spreadsheet (2003)
Caveats for upgrading from Excel 2002 to 2003? (Excel 2002 SP3)
Audit commands: bizarre behaviour (Excel 2002 SP3)
Error on filter in userform... (2000 sr 1)
Formula Description (Result) (2003)
IF OR AND not work!!!! (2000 sr -1)
Reformat data from mainframe report (2003 SP 2)
why 0,00 value not show correct in sheet (2000 sr -1)
wheel mouse scrool text in textbox... (2000 sr -1)
Collage savings (2000)
Calculation Problem (XP2003 SP2)
Hide rows on visible sheets (2003 SP2)
Chart Print Preview in a Protected Worksheet (2003)
Concatenate and space question (2003)
Charting - Line colour for above and below (XL 2K
File Name from a Cell (2003 SP2)
Put calue of cells in header (2000)
Excel graphs again!!! (Office 2003)
Help - About (Excel2003)
Ranking & Sorting Groups (2k3)
Excel graphs again! (Office 2003 )
Why the macro no rename sheet... (2000 sr -1)
Web Save (Office 2003)
Enlarge range Name (Excel XP)
Page Break Preview Error (Excel 2003 SP2)
Null (Excel 2003)
USB Printer Settings in Macros (Office XP / Windows XP Home)
Sharing user defined charts Excel 2002 (Excel 2002)
Auto Recal Reminder (Excel 2003)
Insert values based on selection (2003)
Userforms (Excel 2003)
If And formulae (XP)
Linear Column Chart (Excel 2003)
Devide line by step of aumont... (2000 sr-1)
Countif with conditions (XP)
find (and delete) embedded objects (XL2000 on Win2
Run a macro on deactivate? (Excel 2002)
Opening Personal.xls (Excel 2003)
Must enter value (2003)
Merge tab data (2003 SP1)
Conditional Formatting - example (Excel 97 +)
Repeating Rows? (Office 2003)
Break apart field (2k)
amending a formula (xp2003 sp2)
each 3 month... (2000 sr-1)
Excel graphs (Office Basic 2003)
pasted chart changes date format to number (2002 SP3)
Connection (2003)
Date Format Graph (Excel/ SQL Server)
Not Adding Time Properly (1997)
Changing st, nd, and rd to smaller text (Changing text)
arrotonda per eccesso (2000 sr -1)
why no write in textbox (2000 sr -1)
Images in Excel (Excel 2003)
Add delete rows on protected sheet (Excel2003)
Spreadsheet display alters for different users (Excel 2003)
Distinguish zeros (2003)
Newbie SOS: Sub Won't Run If Workbook Name Changes (Excel 2002)
Need update on formula from Hans (Excel 2003; Win XP)
Dates (MSO '07)
Incrementing Numbers and Text? (2004 for Mac v11.3.3)
For VBA: Excel 2002 or 2003? (Excel 2002)
Newbie needs VBA tweak: icons to text buttons (Excel 2002)
Turning speech off (Excel 2003)
Calculating A Correct Total (Excel 2002 SP3)
Accumulation of Amounts from a table (xp & 2003)
interpolate a value from tables (Excel 2000)
Dialogsheets (2003)
Paste special problem (Excel 202)
Stop loop at specific cell (XL 2003)
Last sunday (2003)
Slow running macro (Excel XP)
Date Formula (2003)
SUMPRODUCT help (Excel 2003)
excel options (ofc 2003 - xp - current)
Case is with global const... (2000 sr 1)
Watch your P's and Q's (All)
what is best way to get totals (2003 sp2)
Multiple Arrays (Excel 2003)
IF Statement With Multiple AND/ORs (Excel 2002)
Waste Report charting (2002)
Peraphs stupid question on scree format (2000 sr -1)
macros assigned to shapes (Excel2007)
Conditional Sum formula (Excel 2003)
Hide worksheet based on a cell entry (Excel 2002)
Building link with filename & path (Office XP)
Macro to copy contents of a row (Office 2000)
arrow key (2003)
count letter in textbox.... (2000 sr -1)
Help with compile error please (Excel 2002)
Converting Excel graphs to jpg (MS Office 2003 Basic Edition)
Configuring autosave (Excel 2000)
Need an error-checking formula, please? (Excel 2003; Win XP)
Lookup Text and Display in Form (Excel 2003)
Opening URL in default browser (Excel 2003)
Need formula, please ? (excel 2003; Win XP)
How do I sort by font color? (2002 SP3)
restrict Scrolling?? (2003 sp2)
Multiple consolidation ranges (2003(11.8012.8036) SP2)
Printing Column Titles on multiple pages (MS Excel 2002)
a formula, please? (2k up)
Serialized alphanumeric formula (Excell 2003)
Identifying print-column breaks in VBA (2000+)
Closing Excel (97)
Comment font and size (Excel XP)
Close Button (2000)
Grouping autoshapes with chart (XP)
Locating cells that are used in formulas (XL 2003)
In-line Help approach (2003 and earlier)
Adding time using months (Office 2003 (SP2))
Set first position of scfrollbar... (2000 sr -1)
Missing Toolbars (2003)
Comments - Cell addresses (Excel XP)
Last Business day of month (Excel 2003 / SP1)
Right Click, cut, copy,paste, greyed out (Excel 2002)
Adding Time Together (1997)
Aborting a Dialogue box (2003 sr2)
Select Cells that are Locked (2003 sr2)
Editing a chart causing Excel to close. (2002)
Paste Special ADD dates (Excel 97 & 2003)
Linked Cells and wrapping (2003 SR2)
Date, Sum Question (2000)
filtre data based value in combobox.... (2000 sr 1)
Slow modification (2003)
Changes to payroll system driving me crazy (2003 SP2)
Duplicates on an Excel spreadsheet (2003, SP2)
index function? (Office 2003)
Replacing reference series in Excel charts (XP 2003, SP2)
PivotTable for multiple sheets (2003)
Time Arithmetic (2003)
make list from directory folder (excel 2000)
delay calculation (Excel03)
Macro signature? (2003)
Macro for Undo (Excel 2002/2003)
Copied Worksheet Looks Different (Excel 2003 SP2)
Convert table that is 366x25 to one that is 2x8761
Showing zeros (Office XP)
Unique Data (2003)
Pivot Tables: Combining data from multiple columns (Excel 2003)
Prevent copy and paste in one worksheet (Excel 2002/2003)
Changeing color of brackets with Code (Excel 2000)
crypting code... (2000 sr-1)
Check for running application (2K+)
% of Change formula (XLS 03)
Disable Worksheet tab right click menu and... (Excel 2000 - 2003)
Macro - password (Excel 2002)
insert sheet name in cell (Outlook 2000)
Random Number (MSO 2003/2007)
Default Email (Office 2003)
Making cells mandatory (2003)
Formula Help (2003)
Increment last value in column (2003)
Excel macro call Outlook error (Excel 2003)
If condition to exclude value in column.... (2000 sr 1)
X close form... (2000 sr 1)
copy formula to summary sheet (WinXP 2003)
Nesting Conditional formulae (XL 2003 SP2)
Page Numbering after page 1 (XP)
Save As Issue (2003 sp3)
Page Breaks (Excel 2003)
Entering times (2000/SP3)
data validation formula (Excel2003)
Auto define Name Range (2003 sp3)
Current Date (MS Excel 2002)
How to deal with huge data volume? (XP/SP3)
Future Value function (offce 2003)
Activate Buttons (2003 sp3)
2000 (Protect sheet but allow autofilter)
Automate break-out of data (2003)
Position screen (Excel 2000)
formula and text in one cell (excel 2000)
Advanced filter - result on other worksheet (2002 sp3)
Highlight rows (2003)
Formula based steep date (2000 sr 1)
match/fill (2003)
formula help (2000-SR1)