Windows Secrets
Windows Secrets Lounge
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)
Can't display Sums (Excel 2003)
Reading 2003 Excel XML (2000)
Hide zero chart results (2003)
pivot table display (Access 03 SP2)
New Features in Excel (2000, 2002, 2003)
Web Query (Excel 2003)
Showing two Excel Open Files on Taskbar (Excel 2003)
Function help (Excel2003)
BOOK1 load (Excel2003)
Labels in Code (xp)
Function not recognized (Excel2003)
Macro Security (2003)
Generate XML Maps (2003)
Spin button which lengthens pictures (Excel 2000)
Leading Quote Mark (Excel 2003)
Possible to auto-create sheet dinamicly... (2000 s
Multi Files with same Button Code (2003 sp3)
Condition format wrong tel number (Excel 2003)
fill (2003)
networkdays (XP)
Errors with embedded Excel file in Outlook appt (2
Average range macro (excel 2000)
Excel 2002 (Trendline - Line & Symbol in Legend)
Possible Corruption (XP)
3d reference (XP)
Workbook open crash (Excel2003)
Finding a date in a range (Excel 2003 SP2)
Extract numbers (Excel 2003; WIN XP)
Add-in requires password on exit (2002 SP3)
Lessons on Import Data (Excel 2003)
Filtre with cboxses and two key (2000 sr-1)
Really Hide a sheet (2003 sp2)
Copy Paste Everyother Cell (Excel 2003)
Date Function (excel 2003)
Pregnancy Countdown (2000)
Midi Files (Excel/office 2003)
wath is this... (2000 sr 1)
summing in next cicle (2000 sp 1)
concatenate by rows (2003)
Inconsistent Printing of Multiple Tabs (2003)
Using a check box to trigger an autosort (2003 SP2
update a cell (exel 2003)
Sorting & VLookup conflict (2003 SP2)
Rnak, median, etc. within uneven sized groups (Excel 2003)
Data Validation - 'Go To' source cell (2003 SP2)
Find blank cell (2003 sp2)
update/link (ver. 2003)
update/link (excel 2003)
Macro to create footer? (2003)
select from item and show data filtred... (2000 sr-1)
Excel Scroll Bar (Excell Scroll Bar)
Excel / IE clipboard questions (2003 sp 1)
Program control of encrypting a file (Excel 2000, XP, 2003, and Offcie 12)
Multiple worksheets (Office 2003)
XLM File (03)
Decimal Places Problem (Excel 2003/SP2)
calender (2000)
Format imported data (2003)
Personal.xls Password (2003)
Lost Thread-Aggregation (03)
Pivot Table - Show Pages Function (Excel 2002)
Controll two dates from text box (2000 sr 1)
Creating a 'roll schedule' (2003, SP2)
vba slow when is in taskbar (2000 sr 1)
Intense macro/Solution Needed (2003 )
Copy table (2003)
Combining Data (Excel 2003)
dubt on import from mdb (2000 sr -1)
Graphs with labels (2003)
Filter Button Color (2003)
Advanced Filter Criteria (03)
Another Row Hiding Macro (2k3)
stoping code (2003)
Format a cell with a custom function (Excel 2000 SP-3)
Prevent Copy (MS Excel 2003)
Palease correct this formula (2000 sr 1)
Please correct this formula (2000 sr 1)
Help to understand a formula (Excel 2002/2003)
code/formula help (excel2003)
DAVERAGE (Excel 2003 / SP1)
Excel formula prob (2003)
Getting PowerPt to respond to VBE (xl2000)
step increase average (2003)
excel charts (2003)
Finding the 'modal' text value (2002)
Data Extract (2003)
change default format (2000)
Hide Columns (MSO2003)
Text Fill-In (2000 SR2)
find method... (2000 sr-1)
Lookup question (Office 2003)
Add-Ins, where to put them (2002)
Adjustable Rate Mortgage vs Fixed (2000)
suggestion to insert line in a txt file... (2000 sr-1)
Does the current cell have a comment? (Excel 97 SR2)
summ based index (2000 sr-1)
Reviewing Toolbar (2002 SP3)
Formatting ColorIndex (2003)
Macro modification for Text file (2003)
Workbook not auto calculating (2002)
Needed help on Median calculation (Microsoft Excel 2003)
Auto Calculation based on cell? (2002 SP3)
Why Doesn
Email all Workbooks in a folder (2003 sp2)
Lookup and copy coordinates (Excel 2007)
VLookup matching 2 items (excel2003)
Sendmail - edit before sending (2003)
Pasting Internet Data into Excel and Dates assumed (Excel 2K)
PV (and FV) Functions (Excel 2003)
date to text (2000)
fetching data from closed workbook (Excel2003)
If formula (Excel 2003)
symbol add-in (2000)
entering a line break in a formula (97)
Excel11.xlb (Excel 2003)
Turn off auto calc (Excel 2003)
Drop down box (2003)
Rolling Moving Average with Blank Cells (2003 SP2)
Repeating text in several cells (Excel 2002)
Macro for conditional formatting, ranking, etc. (Excel 2003)
Autofill sheet references (2003 SP2)
Removing a space (Excel 2000)
SUMIF and LEFT Functions (Excel 2003)
Insert date near cell... (2000 sr-1)
ASAP utilities & ExTools free add-ins
Windows(xxx).Activate statement (Excel 2003)
controll in txtbox go in error (2000 sr -1)
Deleteing lines with other than bold text (2003)
Pivot Table or Pivot Table Report (2000)
Chart x-axis labels won't display (2002/XP)
Pivot Table Format (2003)
Changing date format (2003)
Conditional Formatting (XP)
white background (XP)
view header row at page breaks (2003)
why dupes in jellow (2000 sr -1)
Disjointed sort (Excel2003)
Word Table to Excel (XP)
Design Ideas on automatcally updating an xls (Excel 2003)
Microsoft Query (2003(11.8012.8036)sp2)
Literal '&' (Excel 2k, SP3)
Fill in the blanks (2003)
Setting Up Reminders (Office 2003)
Link manager (Excel 2002)
Copy conditional date (xppro mso2003)
too many different cell formats (Escel 2002)
specialcells not working inside UDF (2000sp4)
MATCH not working? (2000sp4)
Recursing Through Multiple Directories (03)
Multiple Substitution (03)
using default sheet1 in formual (Excel 2000)
fake Access in Excel (2000+)
Shadow Style Button (03)
for Environ('username') (Excel 2002/2003)
InputBox ? (Excel 2002/2003)
Replace the first space (2K3)
Access data retreival (2003) (613144) was moved to the Access board
Pivot Table Totals (2003)
Why Pic not Copy (2003)
Shapes Text (03)
Macro Prevents Paste (2000 onwards)
weird numbers (XP)
Sort Options (2000)
Monthly figure (2003)
Summ +30 to a strng (2000 sr -1)
Page Breaks in VBA (2003)
filtering out info (xp)
Doc embedded in spreadsheet (Excel 2003)
vlookup fired me... (2000 sr 1)
Revert to a default value (Excel 2000 SP3)
drop downs (xp)
increasing var date + 1 day (2000 sr-1)
Embedding Charts in Word (XP)
Row Hiding Macro (2k3)
Excel links square brackets (Excel 2003)
Unique Random numbers (2003)
MACRO - Change the value of a cell with a MACRO (001)
Updating an Add-In (XL2003)
xml and excel 2000 (Excel 2000)
validation limits (XP)
Password a Command Button? (Excel 2002/2003)
Closing Excel (Excel 2003)
concatenate cell (excel 2000)
Events Monitoring (Excel 2003) (611741) was moved to the Software Finds and Wants board
Free Accounting Software (All)
Validation List ? (Excel 2002/2003)
Help Modifying Macro (Excel 2003)
SumIF and SumProduct (2000)
SumIF and SumProduct (2000)
Animated Assistant (2002)
Save issue with multiple workbooks (03)
Macros for Debit and Credits (Excel 2003)
UDF as Addin then emailed (Excel 2003)
Alternate color rows (Excel XP)
change the range of a chart series' Values or XVal (2003 SP2)
copy every thing even if autofiltered (Excel 2000)
Personal xls question (Excel 2003)
Make First 2 Columns Appear on Every Printed Page (2003)
Slash through zero (Excel 2003)
Insert Comment Irritation (2000 sp1)
Worksheet function Vlookup (VB 6.3)
Help with dropdown source in validation list (2003)
Keep Pivot Chart formatting static (Excel 2003)
code security (2000)
Repairing a corrupt Excel file (2003)
Show Formulas, Why? (2K/03)
Extracting numbers is a cell (Excel 2002)
Round Down a date value (Excel 2003 )
Running a Shell command (Excel 2003 SP1)
Cannot get custom filter to work (2003)
picture scaling (Excel2000)
2 Q's on a chart (Excel 2002)
Why are external references absolute? (Excel All)
Make Tables with MS Query (E2K, SP-3)
Adding row to schedule, drag fromulas down (Excel 2000)
brown font (2000)
Vlookup to the left... (Two double zero three)
Converting elapsed time to a date (2003)
Tab Names (2000)
Web Query in Yahoo (Excel 2000, 2002, 2003)
fixed decimal (XP)
Limiting Data in a Pivot Table? (Excel XP)
Selecting several cells at once in a column (2003)
worksheet change event (Excel2003)
multiple replace in string (2000 sr-1)
conditional text replacement (2003)
Scrollbars ? (Excel 2002/2003)
lookups (2003)
Checking against rowsource (MSO 2003 wxpp)
Retrieve Data from Multiple sheets (Office 2003)
Header Row (2003)
Insight into UsedRange (Excel 2003)
External Links (03)
Using Indirect with Array formulas (Excel2003)
Workbook Owner Only ? (Excel 2002/2003)
plot 3 axis chart (2003)
Macro for refreshing ListObject (Excel 2003)
Print (excel 2003)
Send email (Excel 2003)
Excel File opened in Word (Excel 2002)
Wrap Text with Indent (Excel 2003)
VBA and Pivot tables (Excel 2003)
Check Box ? (Excel 2002/2003)
Engineering Function - Imaginary number format (2003)
make error values disappear (2003 SP2)
Refresh All Pivot Tables on All Worksheets (Excel 2002)
Store Data (2000)
Quick way to insert date into Excel (2003)
Workgroup/Shared templates (2003)
current year (2002)
Concatenate a formula (2003)
Keeping Stacked Bars Together (2000)
Unlimited Text Length (2000)
duplicates (XP)
Convert Date Entry (Excel 2003, SP2)
distribute data (Excel 2003 SP2)
refresh link to many sheets (2000 sr 1)
Date Manipulation ? (Excel 2002/2003)
conversion of hh:mm to numbers (sp & 2003)
work with sheet hided.... (2000 sr 1)
text to column won't quite (Excel 2003sp2)
Using wildcard with SUMPRODUCT (Excel 2003)
Check Boxes formula stuff (2003)
fill listbox and conbobox (2000 sr-1)
Macro - If , then (Excel 2002)
Valid Date ? (Excel 2003)
add to a index formula (2000)
Read property of file and store date ... (2000 sr -1)
pivot table using time ( hrs & min) (xp & 2003)
Select doesn't allow me to type in cell (Excel 2003 & VBA)
Exclude cells in calculation (Excel 2003)
Hide Rows ? (Excel 2003)
copy cell value particular... (2000 sr -1)
named formula not refreshing/updating (Excel 2002 SP3)
Selecting negatives... (Excel 2000 >)
Sum 3 largest count values (Excel 2000>)
Link chart title to sheet name (Excel 2002)
combine two stacked charts (Excel 2003)
Subtracting Pivot Table Columns (2003)
Email workbook with message (macro) (2003)
Excell 2000 as checking account (Using Excel 2000 to keep track of checkin
Intercept the real number of line... (2000 sr -1)
Synchronize Charts (Excel 2003)
Cascading Lists over varios sheets (XP SP3 / Gener
hyperlinks (XP)
color cells with macro (excel 2003)
Pivot - drop down list (2003)
Secondary Axis required (2003)
Tab Delimited text - separators (Excel XP)
Stacked bar with totals (Excel 2002)
Restrict Data Entry (2003)
Exiting a macro if wrong worksheet (Excel 2003)
if delete line formula not work (2000 sr 1)
DropDown-select one value, fill another (XP)
HLOOKP (Excel 2003)
oh, oh excel go in task bar... (2000 sr 1)
Multiple IF AND Conditions (Excel 2003)
Pivot Table problem when updating (2003)
Dual X axis (2002 SP3)
Data Query Issue (2003)
Excel Closes unexpectedly (2003 SP2)
isolate code to stay in module (Excel 2000)
Formula for Data Selection (2003)
logic if cell is blank (excel 00)
Find Reference (XP SP3 / General)
Automatic completing full names in cells (2003)
Formulas (Excel 2003)
menage event option button... (2000 sr-1)
subtract from higest in the group (excel 2000)
Excel Load to Access (03)
vlookup (xp or 2003)
Formula to Replace Blank with Zero (2002)
Growth Percent Formula (Excel 2000)
Find in multiple sheet... (2000 sr 1)
Found string 6 right... (2000 sr 1)
Screen display problem (xl2003)
Pivot Table adjacent cells (XP)
Bar Chart Axis Labels Order (2003)
Select random cells - not random numbers (Excel 2003)
Print Dialog arg: ? (Excel 2002/2003)
Automatically importing a column-delimited text fi (2002)
Named Formulas and Conditional Formatting (Excel 2002 SP2)
Find Row Number (Excel 2003)
BMI Formula ? (Excel 2002/2003)
Subtotal removal in 2007 (Excel 2007)
Scroll Menu (2000)
Multiple row selection, copy to Word (2003)
Add value in vertiocal and horizontal .... (2000 s
SaveAll (Excel 97+)
Placement of Code (XP)
Error Message - Personal Workbook Macros (2003)
Create an Excel Object from ASP code (Windows XP; Office 2003)
Excel Help Menu (Excel 2002 SP3)
Displaying a variable value (Excel 2000)
Know the real name and surname of user logged... (2000 sr 1)
Open Documents in Task Bar List (Excel 2003)
Conditional Formatting Formula Help! (2002)
Alter numbers in a range of formulas (Excel 2002/2003)
Excel training guilds (2003)
RSS feed in Excel (2003)
Dubt on column count... (2000 sr 1)
Determining if a File is Open (Office 2003)
Flyout Menu speed (2003)
dinamic column.... (2000 sr 1)
Join cells do until... (2000 sr 1)
Calling a Visual Basic procedure from Excel (2000)
Grabbing that slippery chart object (2003 SP2)
conditional formula (XP)
Personal.xls (2003 sp2)
Camera feature (Excel 2007)
Function translations (All)
copy linked sheets (excel)
insted cells use range column... (2000 sp 1)
EXCEL Closing (2003)
Upload data to Excel (Office XP)
Macro help (Excel XP)
Need info seperated.... (2003)
Excel 2003 compatible with 2003? (Excel 2002)
Case Statement (2K)
chr(182) - in comment? (excel 2002)
why the macro copy not want i want???? (2000 sr-1)
Multiple Checkboxes (Excel 2003)
Grouping Rows (03)
Lock Name LIst (2000)
controll date in entry.... (2000 sr-1)
Count instances of a letter in a range of cells (2003)
break protection in excel (excel)
Select All Worksheets Macro (Excel 2002)
SQL Statement (SQL)
Editing Comments (any)
Parse variable string (excel 2003)
Auto filter spinner controls (Excel 2003)
Debugging a pivot table problem (2003)
Tab Sum (2000)
moving within a selected range (2003)
Find and Replace in VBA Object (Excel 2002/2003)
Charting Dates and names (Office 2000)
E_MAIL AND MATCHIN... (2000 sr-1)
When is it a nest! (2003)
Who has MAX/MIN sale (Excel 2003)
Create an AutoCalc on right click. (Excel 2000 >)
RoundUp to 10th (Excel 2003)
User-Defined Function (2003/SP2)
Workbook objects loading after Open event (2003)
Copy range from several worksheets for printing (xppro 2003)
Copy Paste Macro (Excel 2003)
Show Filter Criteria (2002)
Validation lists (Win XP, Office2003, Excel)
Excel to Word Mail Merge (2003 sp2)
Working with Bubble series (2002)
delete cells boh! (2000 sr-1)
navigation keys don't (03sp2)
Rate and Duration (EP PRO SP')
Linking Files with Redirect (03)
Re dock my Project Explorer (XP)
Got to be a better way. (Excel 2003)
macro to clear check boxes (ms office 2000)
vlookup woes (xp & 2003)
Using Range Name to Contain An Array Formula (all)
MAcro Button (2000)
min max date (2000 sr-1)
dynamic range (Excel 2003 sp2)
Newly created sheet needs a Change Event (Excel 2003 & VBA)
Dynamic dropdown list or radio buttons (All)
CHECKBOX_ATTUALE is optionbutton.... (2000 sr 1)
'transfer' filter? (2kSR1)
Week number (2003)
Using a textbox input as variable (xppro 2003)
protect worksheet but run macros (Excel 2000)
Decrease value in cell based on VLookup (2002/2003)
insert time on real time... (2000 sr-1)
determining the value of intersection (Excel/2003)
Search/Replace Error Code (03)
Track Changes (2003/SP2)
Hide Rows In HTML Export (2003 SP2)
Missing Handle (2003 SP2)
Summary Sheet shows content from other worksheets (Excel 2003)
Auitofilter and copy down (Excel 2003)
Fixed Objects Will Move (2003 SP2)
Remove Blank Entries (No VBA) (2000)
Import csv files (Excel XP)
Excel Charts on Sharepoint (XL 2003; Sharepoint Se
Templates (2003 SP2)
Time in formulas (2003)
Conditional Formatting Question (2003)
Object not set (Excel 2002)
Text appearing as # in text-formatted cell (2003 SP1)
Text not being show in cell correctly (2003)
File Import (2003 SP2)
Apply format alternately (2003)
Cell Change Event (Excel 2003 & VBA)
Automating a score sheet in Excel (Excel 2003 SP2)
Aligning charts (2003)
Changing cell formula is other cell changes (Excel 2000)
Chart - Hide Zeros (2000)
Auto Calculations (any)
add comments to buttons (excel 2003)
Missing Sheets (03)
Cell element of Range? (XP SP3 / General)
Lookup anomaly (Excel 2002/2003)
formulas (windows 2000)
Help With Date Formula (XL03)
ComboBox issues (Excel XP)
Creating from Multiple Spreadsheets (Excel2002)
macro warning... but no macro (2003)
Find Focus (2003)
Union of Two Ranges with Advanced Filter (03)
Excel Pivot Calulated Field (Excel 2002)
Pass cell address or text to formula/function? (Ex
Removal of end characters from cells (2003)
graphing (excel 2003)
CriteriaRange (03)
Range Specification (2000)
stripping links (Office 2005)
If Range is NOT NULL... (2003)
IF & OR Condition (Excel 2003)
Rounding off Percentage (Excel 2003)
Conversion of lower case characters to uppercase (2003)
Merging rows and preserving the data (Excel 2000)
count value with lookup (2000 sr-1)
Deleting VBA modules (Excel 2003)
Auto Calculate Macro (2000)
different results (2003)
zooming in on graphs (2000SR1)
EPOS Customer Display (Excel XP)
Read only message when open file (2003)
Month text to number (2003)
Auto updating a pivot table (2003)
Hyperlinks within Excel (2003)
Change Form Controls (2003/SP2)
Data Validation list in another workbook (Excel 2002)
MS Query (joins) (2003 SP2)
macro help (excel2003)
Adjust rows and columns (2003)
& in header (2003)
Validation Problem (Excel 2002/2003)
Totals of variable data (2003)
Subtotals (2003)
Dynamically insert code into an Excel module. (Exc
Help of Formula Needed (Excel-2003)
Validation list navigation (XP>)
Split a list over 2 columns (XP>)
Control the Data Form? (XP>)
Rank of a number (2003)