Windows Secrets
Windows Secrets Lounge
VeryHidden Sheet References (03)
Cannot evaluate formulas in Excel (2003)
Opening Excel Via Outlook (2000)
File opening and starting Outlook Express (2002/10.6501)
Today date in range of dates (Excel 2003)
Loop (Excel 2002)
Creating a consecutive date list (Excel 2003 SP1)
Fix dates with missing years and day (Excel 2003)
Running total for categories in a work book (2003 SP2)
Copy and Paste Problem (Excel 2002/2003)
Identifying Excel Application/Workbook on Server (03)
Deleting specific text (2002)
Draw Spiral (XP)
concatenete cells in one... (2000 sr-1)
Import multi text into one workbook (Excel 2002)
Add-in (2000 sr-1)
Filter results count in Staus bar (XP/2003)
Importing numbers from CSV (Excel XP)
Copy/Extract Info from one Spreadsheet to Another (Excel 97)
Count Unique AutoFilter (2003)
formula to get data from Open Workbooks (Excel 2003 SP2)
Save Values to new worksheet (Excel Ver 11 (2003))
countif with dates (2000)
break formula into time? (Excel Office 2000)
Named ranges global vs. local (Win XP, Office2003, Excel)
Suggestions (2003)
E-mail Macro (2000)
Auto Correct (Excel 2003)
Query from Access to Excel (2002 SP3)
find closest value ?? (Excel 2000)
Calling macro from anther spreadsheet (2003)
Text size in Drop Down lists (2000)
Userform Question (Excel 2002/2003)
Combine separated print selections on one page (20
nper??? (2003)
Call Subroutine (Excel 2003)
jdt files (2000) (593937) was moved to the Software Finds and Wants board
trigger Email from Excel (2003)
WebGenii PayPal HTML Generator.xla (Excel 2002 SP2
What's slowing my macros down? (2003 SP2)
Mail Merge (2003)
ignoring 0's and getting min (Excel 2000)
No of instances in a list (Excel 2000 SP3)
Excel 2007 Sheet Size? (Excel 2007) - RESOLVED
Weird new Key Comb. for Current Region... (Excel XP/2003)
Printing Entire Workbook problem (Excel XP)
Series Emphasising Chart (Excel 2000 >)
Highlighting a row (Excel 2003)
Search function in a macro (Excel XP)
Open File ReadOnly (03)
superscript in cells (excel 03' sp2)
Pivot Tables and Landscape Orientation (2003 SP2)
Save excel file temporary (excel 00)
Bar Chart (2003)
Can't delete comment (Office 2000)
UDF function and macro (2003)
Selecting Large Data Sets for Graphing (2003 SP2)
worksheet formula (2000)
formula to take out all except end (2003)
Coloring Worksheet Tabs within a Workbook (Excel 2000)
Repeating a print job (Excel XP)
formula with an external reference Invalid (Excel 2000)
Cell Name (03)
SUMIF with multiple criteria (Excel 2003)
Cell won't take formula (Excel XP)
Formatting a .csv file [Help Please] (2003)
median monthly value (2003)
Compile Error (2003)
clear cell if its colorindex = # (excel 2000)
pick list and VBA (XP)
PDF differance in Excel 2002 & 2003 (Excel 2002/3)
Resize Save As box (2003 SP2)
Excel Loan Amortization Template (2003)
Changing decimal of y-axis of a chart in vba (Excel (macro))
Auto Refresh Pivot Table with Auto Calc (2003)
Multiple values in a column for Filter? (2000)
Unprotect Worsheet to run Macro (2000 SR-1)
Countif and the Right function (Excell 2000 or 2003)
Macro ([bash])
Open Word from macro problem... (Excel XP)
Combobox (2002)
Structure long daily chart of meds and test result (Excel Office 2003)
Events in Excel (Win XP / O2003 UK SP2)
Trend Function (Excel 2003)
Protect specific columns (2002)
Countif with two criteria (2003)
Conditional Formatting Formula (Excel 2003)
Conditional Formatting VB (2000 SR-1)
Combining MATCH with Autofilter (2003 SP2)
Excel won't read Quattro Pro (xp)
complicated formula (2003)
Printing from a macro (Excel XP)
Clear Drop Down in Pivot Table (2003)
Save Worksheet in different workbook? (Excel 2000/2003)
Tab Names (2000 SR1)
Bold and size text in the formula bar. (Excel 2003)
Searching for * character (XP/2002)
2 Vlookup Q's (Excel XP)
comparing two text (excell)
Unprotect workbook (2000)
Combobox (2002)
Charting per date range (2003 Sp2)
replace #DIV/0!
Extract data-left, right, med-from a cell(2002)
Open Hyperlink and copy data (XP)
Conditional Formatting (Excel 2003)
Formula Problem (Excel 2000)
SUMIF (Excel 2003)
Criteria Assistance (03)
Delete Duplicates (2002)
Display results from search on one worksheet (Excel 2003)
Changing cell references (2003 SP2)
Can you duplicate relative references in a formula (2003/SP-2)
Moving from 1 cell to another (Excel XP)
Move or Copy any File to New Folder (Excel 2003)
Macros (03)
[pn':DcmnsadStig\h srM ouet\ (Excel 2002)
Pivot table page field (Excel 2003 sp2)
Pivot Table & Averages in Calculated Fields (Excel 2003)
Transpose data from 1st sheet to the other sheets (2003 sp2)
Can't use ADDRESS within an OFFSET (2003/SP-2)
Inserting Page Numbers (Excel 2000)
Pivot Table Max Characters (Excel 2k)
Removing apostrophes (2003)
data cleansing (2003)
Object required (2002)
Test For File Open (03)
Macro triggered by target cells (Excel 2000)
Negative Cell (Windows XP)
Display as Icon (2002/SP3)
Have no Idea what happened. (Excel 2000)
File Corruption? (03)
Pivot Table Sum (2003 sp2)
Protecting/Unprotecting (2000 sr-1)
Multiple If Conditions (Excel-2003)
count value with exclusion... (2000 sr 1)
Delete Superflous Rows (Excel 2000/2003)
Code Assistance (03)
Size of Excel file (Excel 2003)
Code Hangs (03)
Protect Formulas (Excel 2003)
xl2003 transalation? (xl2003 sp2)
Cell Grouping (03)
New List from Existing List (Excel 2003)
PivotChart - help! (Excel 2002)
calculating workdays from an exit date (Excel 2003 sp2)
Dynamic Range Column Count (03)
object not found (Excel 2003)
Turn off automatic formatting (XL 2003 SP2)
Excel 2000 SP3 (always open displaying a specified
Subtotal Formula with a Catch (Excel 2002)
Date Calculation (Microsoft Excel Worksheet 97)
image control (Excel 2003)
Paste special affecting graph formatting (2003/SP1)
=sum in variable (2003)
skip in blank cell inseted column... (2000 sr 1)
Sort Addin? (Excel 2000/2003)
Entering multiple lines in a cell? (2003 SP-2)
Conversion of dates to decimals (Excel 2003 SP 2)
Rates (2000)
Display Active Cell (Excel 2000 SP3)
Mailto: Subject (Excel 2000/2003)
Sort Macro (2003)
Hidden excel file open (excel 2000)
Synchronized drop downs (Excel 2003)
Text or Number (Excel 2003 VBA)
SUM based on MAX Condition - Round 2 (2000)
Comment Cell Location (Excel 2003 VBA)
Excel .tmp files (2003)
Formula help (AVERAGE function) (Excel 2003)
workbook close (Excel 2003)
Select a cell in a macro (Excel 2002 SP3)
One Cell Into Many Rows (Excel 2000)
Highlighted Text, Creating Macros (Office 2003)
Move Rows to another sheet (Excel 2003 SP2)
link or copy? (Excel 2003)
Creating Duplicate Rows based on a cell (2002)
Proper Function with Plural Words (2002)
Distribute An Amount Over 12 Periods (03)
Bar Chart in two cells not sized per percentages (MS Excel 2002)
Special Formatting For Elasped Time (03)
Forms and stuff (2003)
#value! (Excel 2003)
CombineallSheets macro (2003)
sum color cells (excel)
X-Axis Label problem (2003)
Scatter graph question (Excel 2003)
Removing invisible characters (Excel 2003)
Invisible characters (Excel 2003)
Tried Decryptum or PasswordNow ? (97-2003)
Pivot Tables (2003)
Round to nearest .125 (2000)
Upper case conversion (Excel 2003)
Excel Merge (Excel 2003)
Deleting words and not numbers in a cell (2003)
Deleting Sheets via macro (2003)
Macro to delete from autofilter (2003)
Open Browser and Fill Forms (XP) (588126) was moved to the Web Design, Coding and Scripting board
Stacked Bar Chart Display Problem (2003)
OVERLFOW (Excel 2003)
VBA Split Challenge (Excel 2003)
Transpose Formula Challenge (Excel XP)
Formula Problem (Excel 2000/2003)
Rebar Cutting List (Excel 2000)
UserForm Caption (03)
date/Time math (Excel 2000)
Converting Feet and Inches (2000)
Excel Pane Too Big For Screen (2000)
Reformat a cell reference (Excel 2003)
Desktop Shortcut (2003)
auto name sheet (Excek 2000 9.0.2720)
Date math (Excel 2003)
Free Excel workbooks (2000)
Print Titles (2000)
Formula/Macro to lookup oldest product quantities (Excel 2002)
Shortcut to switch tabs (worksheets) (2003)
Changing an axis label (Excel 2003 SP2)
Coding features of Ecryption (Excel 2000 - 2003)
#REF (2000)
Conditional Formatting (Excel 2003 SP2)
To Wrap or Not To Wrap (03)
Currency Formatting (Excel 2000)
RETURN KEY VALUE? (Excel 2003)
Enter a number in Feet/Inches (2003)
How to loop thru worksheets without selecting them (Excel 2003)
ComboBox Selection (03)
email using a Routing Slip (Excel 2000 Sp3)
Refresh data - button (2003 SP2)
Macro to open email template (XP)
inested fixed range... (2000 sr 1)
Can't add to formula (Excel 2000/2003)
Opening worksheets (Excel 2003 SP2)
LOAD Userform from another workbook (Excel 2003)
Userform unloaded not hidden (2003)
Delete certain rows but not others (XP)
Formula R1C1 (2000)
Help with Data Validation (Indirect) (Excel 2002/2003)
Missing sheet tab (Excel 00)
Looking up (XP)
Convert Text To Hyperlink (XP)
Waiting for Queries (XL2003)
ASAP Utilities 4
AutoFill (2003)
Numbering Problem (Excel 2000)
Excel Macro (2002/03)
Unresponding ListBox on a worksheet (XL2003)
Unable tosave external link values (Excel 2003)
Combining 2 or more IF statements (XP- 2003)
formula variable auto calculate (2000+)
Count but ignore Duplicates (Excel 2002)
Can't set MaximumScale of axis (2003)
Nested IF Statement With Percents (Office 2000-2003)
Delete line if... (2000 sr 1)
Formatting Another Sheet (03)
sorting different date styles (Excel 2000)
WORDS FLASH ON AND OFF (OFFICE 2000)
Determine Month of Class Attended (2003/2003)
String find within String (Excel 2003)
Pivot Table with lots of data (2002)
Worksheet.Select Problem (Excel 2000/2003)
Update Prices (2003)
Count (Excel 2000)
Image Control automation error (Excel 2003)
Indirect Links (Excel 2000 or 2003)
Custom Views (2003)
Excel Macro (Excel 2002)
Percentage calculation (XP)
Worksheet picture Control (Excel 2003)
Excel2003 losing printer? (Excel 2003)
Merge text content (2003)
Creating a new row for each item in a cell (Excel 2000, Win 2k)
conditional formatting (Excel 2000)
VBA window (XL2003)
Help with Formula (Excel 2002/2003)
Tricking out a spreadsheet (Excel 2003 SP2)
Warn if printing more than 1 page wide (2003 SP1)
stepping (2000)
colorize cell if... (2000 sr 1)
Create a list from spreadsheet structure (Excel XP)
Odd data (Excel 2003)
make a Selection and double the value (Excel 2000)
Offset calculation in VBA (2000)
use a command via shell (2000 sr-1)
Using VBA to modify another file's VBA (2000/2002/2003)
Seperate fields (excel 2002 sp3)
Link table from another sheet (similar to Paste Li (2003)
Formula for Extracting values (Excel XP)
Count occurances between dates (2003 SP2)
Re-Index Worksheets (Excel)
How does this work (Excel 2002/3)
Stripping Macro's (Excel XP)
Hide or lock a specific module (2K3)
Time field not recognized (Excel 2003 sp2)
Footers (2003)
Excel sum conditon (excel 2000)
Ecrypt contents of an Excel file (2000 - 2003 )
Pivot Table Calc Items (Excel 2002)
Filesearch property (Excel 2003)
Calling Function in another Workbook (03)
Avg, Min, and Max Extraction (2000 SR-1)
Folder Contents (03)
Negotiate A Range (2002)
Summing Every Other Column/Row (2000)
Recover Corrupted files (2003)
SERIAL number of date (2000 sr 1)
Match Problem (Excel 2000/2003)
the file is free? (2000 sr 1)
Multiply Function in Macro (Excel 2002)
Conditional Statement based on range + fill color (Excel 2000)
excel 2003 drop down menu hangs (Excel 2003)
Check Boxes (XP)
Ideas for sorting multiple worksheets (XL 2003)
Summerize Data (Excel 97 & 2003)
OnAction oddity (2003)
Forms Tools (2007)
Different Results with IF() (Excel 2003)
Query data in access (2003)
Filter to show duplicates including original (Excel XP)
ordering with twoo key..... (2000 sr-1)
copy&paste without formulas (excel2003)
Counting (97now, soon 2003)
function (2000)
Cells overwriting adjacent cells (Excel 2000 SP3)
Printing the first page on different paper (2002)
Macrofun (Any)
Filters - File Dialog (2004)
Merged Cells and Hyperlink (03)
conditional format (2003 )
Dragging (filling) transposed values (Excel 2000 SP3)
filter out single entries (xp)
Chart: forcing a line between non contiguous value (Excel Office 2003)
display new workbook (xl2003sp2)
Bar Graph Colour (2003)
pivot table created subfolder (Excel 2002 SP 2)
Autofilling cells with data from another sheet (2002 SP2)
ISPMT vs IPMT (2002)
Excel Line Chart (2000)
Pivot table problem (Excel 2003 11.56.12.5606)
Date Format (Excel 2002)
Setting up an IT Help Desk Report (2003)
Connecting to an Access database (2002/SP 1) (581958) was moved to the Access board
Counting number of row entries (2003)
Extract data from Word forms & feed into Excel? (2003)
Does Sheet Exist (03)
Unhide All Worksheets at Once (Excel 2002)
Precision of a number in a formula (excel 2000)
Macro to map a drive (2003) (581759) was moved to the VB / VBA board
insert subtotal refred block (2000 sr 1)
Percentage.... (2000 sr 1)
Excel Macro (2003)
Refresh Pivot Table Macro (Excel 2002)
Macro to Delete Contents (Excel 2002)
Autofill linked cells within a workbook (Excel 200
Analysis Tookpak (03)
Page numbering (2003)
105 MB file - Please Help (Office 2003)
paging thru excel with a mouse click (2000 SP3)
APP PATH... (2000 sr 1)
Searching multiple sheets (Excel 2000 v9.0)
extract specific abbrev to other column (excell)
Matching values (2000, 2002)
Sum alternate cells (Excel 2000 SP3)
Repeating data (Excel 2002)
Select Cell that equals Today (2K/2K3)
keyboard shortcuts (Office 2003)
insert a whole bunch of csv files (2003)
simple formula... (2000 sr-1)
INDIRECT as part of Array formula - hows it work? (excel 97 on win xp sp2)
Custom Excel Color Palette Problem (Excel 2003)
Not enough system resources to display completely (Excel 2000)
Extrapolating data in a table (excel 2000)
Copying from pivot tables (2003)
error 3001 from excel to SQL Table (2000-sr1)
iMPORT TXT... (2000 sr-1)
Prevent File Copying (MS Excel 2000)
Projection Formula Problem (Excel 2000/2003)
Page size in Excel workbook (Excel 2003)
Any shortcut to update linked formulas? (Excel 2003)
Filename & pathname restriction in file open (2002, XP Pro SR2)
Dates & Time (Excel 2000/2002)
Bold Certain Text (2002)
Comparing workbooks (Excel 2003)
Getting Pivot talbe data (Excel 2003)
Combined dynamic named ranges (Any)
Fixed Field Length Export File (EXCEL XP [2002])
Added line in spreadsheet (2003)
Consolidate Data (Excel 2000/2003)
Print Selection (03)
Autoformat (XL 2003)
Combine Data from Multiple Worksheets (2003)
ADO Refresh (03)
serac in column, copy and delete... (2000 sr 1)
Help with an AverageIf function please... (Excel XP)
Cell After Update function (Excel 2003)
Rounding to a quarter... (Excel 2000 >)
Decimals in Excel (2000, 2002)
making adobe files from excel (2003)
Clear cells in a range per sheet loop (ecel ms office 2000)
blank cells which aren't! (XP)
Delete data but preserve formulas (Excel 2000)
Help with Message Box (Excel 2002/3)
Last Line On A Page (2000)
Sort an array (2003 SP2)
Copying/printing certain worksheets (2000)
how to plot filtered data only (2003)
sumif two condition not works (excel)
Macro for each sheet (2003)
DROP DOWNS THAT NAME SHEETS (EXCEL MS OFFICE 2000)
Upper Worksheet Function (03)
Covert postive values to negative (2000., 2002, 20
fiil list box based chkbox (2000 sr 1)
Replace a stringed date into date (Excel 2002 SP3)
Counter button in Excel (Excel 2003)
using user form text value (excel ms office 2000)
How to make a percent in VBA (2003)
File Names (2003)
ActiveWorkbook.EnvelopeVisible (03)
Gannt Charts (Excel XP)
Link to another post (2003) (579128) was moved to the Lounge Matters board
Limits on number of characters in a cell? (Excel 2003)
Saving a workbook in Excel (XP)
Largest & Smallest unique numbers (2000)
Macro alert (Excel 2003 sp2)
Struggling with Formula (Excel 2002)
HEAD FIRED!!!!! (2000 sr 1)
Pivot Table Spaces - Fill with Above (Excel 2002)
Macro Password Removal (Excel 2002)
Multipage user form tab names (Excel Office 2000)
Sumif first three digits of number are xxx (2000)
count rows with text (excel 2000)
saving as a template (Excel)
Compare Pivot Table Data Values (Excel 2000, SP3)
range value in vba, with number format (Excel 2000)
Converting number to Dates (Excel XP)
Changing Default Cell Border Colors (2000)
Command Button - Assign Macro (Excel 2002)
Delay is changing folder (2003)
Useform and dubt and prob.... (2000 sr 1)
Form - drag control (Excel 2003)
3 chkbox particular... (2000 sr 1)
Spreadsheet Errors (all)
vlookup return value (2000+)
Data Validation not working (2003 SP2)
Whats the significance of 'RC' (Excel 2000 >)
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)