Windows Secrets
Windows Secrets Lounge
auto fill cells (excel 2003)
linking many cells (2007)
Sum (2003)
Bank statement (2003)
Automatating sending spreadsheet (2003)
Running 2 instances of Excel 03 (XL2003)
Cannot Open VBA Project (XL 2K)
Divide by zero error (XP)
Fille the first item in combobox with value (2000)
Looping sheets in wbook... (2000)
Alter Default Color Palette (2002 SP3)
Set default value to cells on worksheet open (2003)
fixed versus round (XP)
Corrupt excel file (2003)
Manipulating Horizontal Data to Vertical Data? (Excel 2003 )
default to excel 2002 instead of 2007 (Excel 2002)
excel sort (2003)
Negative number of days... (2000)
Control Tab Order (2003 SP3)
Assign a new number (2003)
Count of Color Formatted Cells (2003)
Macro date problem (2003)
SHOW all data if column is filtered... (2000)
Paste into Cell (Excel 2007)
adding simple math functions to pivot table (xp & 2003)
Variable Ranges in VB (2003)
Can't update a pivot table (Excel 2003)
Concatenating Data (2007)
AutoFilter Custom List (2003)
reverse FINDSERIES (v2003 sp2)
But how to delete button... (2000)
Sort sheets (any)
Chain Excel Sheets (any)
PageBreaks (2000)
Looking up Values (Excel 2007)
brain tester maths problem (2003)
Print Area Display (Excel 2003, SP2)
Linking (XP)
Won't Save (Vista)
CurrentRegion Last Cell (XP)
Force Data Entry (XP 5.1.2600 SP3)
DialogSheets, adding controls (Excel 2007 SP1 MSO)
sort active list (2003)
VBA code window (Excel 2003 SP3)
Opening a CSV File-Format Changes (XP)
Carriage return in textbox not work correct!!! (2000)
Still on looping... (2000)
Summarising Comments (2007)
Decimal places (2007)
Date Formats (2003)
Message box whilst vba running (2003)
Coloring Line Graph Points on Condition (Excell 2003, Off Prof 2003, Win 2000)
Excel - 'Ready' area at the bottom of screen (Excel 2002)
display date values in pivot table data field
Concatenating Functions (Excell 2003, Off Prof 2003, Win 2000)
loop only work day (2000)
error 1004 when opening workboek (XL 2003)
Return address cell via code (2000)
Conditional Formatting (Excel 2003 / VBA)
Macro Playback (2003)
Remove spaces from centered data (2003 sp3)
Combine all Workbooks (2003)
listview problem (2000)
Default Sort Header Row (2003)
Statistical chart (Excel 2003)
Multi Area Header (2000)
Macros/Short cuts (2003)
Using LOOKUP formulae (Excel 2003)
Print area (2003)
Charting tabular data (2K3)
Add-ins (2003)
Decimals (XP)
save all component in project... (2000)
Colour of Shapes by value (Excel 2003)
Sumproduct (Excel 2003)
Drop down lists (Excel 2003)
Pivot table sum too long (2003)
Mail Merge with Variables (XP 2002)
VBA Training (2003)
vlookup using multiple columns (win XP, Office 2k)
input form (xp & 2003)
Storing macros (Excel 2003)
mail merge problem (xl2003sp3)
Sort (2003)
Adjusting dates for DST (2003)
Count conditions (2003)
Programmatically Add Buttons (2K and higher)
Convert a real number to decimal (2003)
split into multiple rows (2003)
INDEX function using labels (2003)
Copy formula also copies values (2000 / 2003)
Max # of worksheets / names per file? (Excel 2003 )
VBA for Pivot Table Current Page (Excel 2002)
line-column chart (2003, SP3)
use 'left' in VBA (2003)
TOOL BAR (2003 sp2)
Insert Macros (Excel 2003)
Universal Macro (2007)
VLOOKUP Error (MS Excel 2003)
only allow unique value in cell (xp 2003)
If the .. multiple choice.... (2000)
Copy from user defined file (Excel 2003)
Sort / Filter (2002 / 10)
Fill cells with day of month... (2000)
Copying data from One Workbook And range valuing (Excel 2007)
Call a Subroutine Using Variable (XP)
Keep focus on cell (XP SP3)
sum matrix values (2003)
computer specs for working with Excel (2002 SP3)
Number increments (2007)
Formula's > VBA (2003)
IF Function (Excel 2003)
If statements (MS 2003)
Multiple IF statement (Excel 2003)
Updating links (Excel 2003)
Locked Workbooks (XP)
Filtering information (XP)
Separating data into worksheets (2003)
Wrapping text problem (Office 2003 SP2 )
Incomplete Chart Painting (2003 Pro/SP3)
Range Problem (2003 SP3)
Fill trailing spaces (2003)
Macro to add to a formula (2003)
Entering Time (2003)
Excel Maximum Sheet Count (2003 or 2007)
Paste Traspose from File to File (Excel 2007)
Expanding Chart (2002)
conditional Formatting based on another field (2003)
VLOOKUP result with VERSCHUIVING (OFFSET???) (2002 SP3)
Loop thru named ranges (Excel 2000 - 2007)
Kilometer/Mileage Calculator (Excel 2007)
Sum based on color (Excel 2003 )
Add Column based on dates in another column (Excel 2003 sp2)
Macro Security (2003)
Cascading data validation issue (2007)
Setting a format within an expression (2003 sp3)
SolverAdd function problem (solution) (2003)
File name (Excel 2002 SP3)
How to not print the hidden rows (2003)
COUNT IF (excel 2003)
Auto-filtering with multiple criteria (Excel 2003)
positive numbers to show plus sign (XP 2003)
test on text value before using sum (2002 SP3)
Cannot delete rows (2003)
MultiSheet selection (2003/SP3)
Two Axis Column Chart Anomaly (2003 SP3)
Pie chart - Percentages not correct (2003)
Forbid changing cells (2k)
EXCEL cell properties
Pivot chart loses data (2003)
Chart - extra dates are appearing (2003)
Expand IF statement (2003)
Excel wookbook (2003)
Preview Pane blocks Personal.xlsb (2007 on Vista SP1)
Pivot table or use a filter? (Excel 2003)
Date & value (2007)
Pastel Color Palette (Excel 2003)
Macro not working (2003)
Pick the Correct Quartile (Excel 2003)
value for year.. (2000)
Data Table Error (MS Excel - Office 2003)
Excel (Set up work sheets)
Pivot Table- Month Year in order (2003)
complex graph (EXCEL)
Lookup and summ... (2000)
Conditional Format? (Office 2007)
Hiding rows (Excel 2003)
Bar Chart (2003)
File | Send to... (2003sp3)
macro (Excel 2000)
Using a Macro in IF Statements (2002)
PV() worksheet function (2002)
Pasting to PowerPoint (2003)
Put dummy data in all empty cells (MS Excel 2000)
transposition (2003)
Worksheet change event (2003 SP3)
counta issue (xp & 2003)
Curious Issue - Error? (2003)
from VB to VBA (2000)
Totals (Excel '07)
Nested IF/AND with lots of ORs (2003)
Nested IF, AND, OR (2003)
Copy down problem (2003)
CountIf problem (2003 SP3)
Allowing use of Pivot Tables; protected sheets (Excel 2003)
removing (Excel 2003)
duplicate records (xp & 2003)
Lookup row based (WinXP SP2, XL 2003 UK)
Excel comment cells via VBA (Excel 2003)
Autosave to Different File Path (2003 SP2)
remove time from date field (Excel 2003 / SP2)
Compiling Error (Excel 2003 SP3)
Conditional Formatting through VBA (03 SP 3)
Find location of name (2000+)
Find symbol (Excel 2003)
Convert dates in Excel (2000)
Need Data to Pull From Multiple Rows (excel 2007)
Data Validation Alternatives? (Excel 2002)
Format of a date time (Excel)
Edit data validation list (2003)
Error #: 1004 (Excel 2003)
close all wbook ... (2000)
date Conversion (2003)
difference EMPTY and ='' (2000)
Format number puzzle (2003)
Over the maximum columns (Excel 2003)
Have Excel Save Workbook every night (Excel 2003)
Insert PrintDate? (Office 2003)
Linked Excel charts not updating (2007)
Custom Function (2002)
Formula (2003)
Excel Charts and Data in 07 (2007)
Have the autofilter function work across columns (2000)
Copy Fill Assistance (2003)
Dubt and cleariy on counter line (2000)
Format string (2000)
Template Filesize (2003)
Formula explaination and help (2003)
Creating a macro with formatting (2002/Rel. 10)
ISERROR question (2003)
Moving a row based on the time (2007)
Weighted Average With Exclusions (Office 2003)
Save Chart (Excel 2003)
Help on code (2003)
Delete Rows (2003)
Monster Loop (2003)
Record - Playback (2003)
Date format (2007/2003)
Deleting rows based on values in two cells (2007)
Excel & different numbering systems (2003)
Capitalize first letter in cell (XP/2003)
array value in string (2000)
VBA or Macro code to print (Excel 2007)
Converting a PDF file to Excel (2003)
Excel Macro to Send Email via Lotus Notes (Excel 2002)
Open to Default Worksheet (Excel 2003)
Conditional Formatting or other method (2003 SP2)
Old formula Help needed (2003)
Using Range Names as series in charts (2003)
if statement to change color of text (excel 2003 sp 2)
Spreadsheet slow to print preview (2003)
Data validation; conditional formats (Excel 2003)
Turning time into a decimal (2003 SP2)
First 20 rows containing a value (2003/SP2)
Change 'cell block' Color (Excel 98 and higher)
loops and validation (excel/vba)
Data Merge HELP! (2007)
Help with formula for counting (2003)
Import Data (MS Excel 2003)
Restore Rows (Excel 2000)
Formula Help (Windows 2003 Service Pack 2)
commandbutton1_click (2003)
CAGR function (Excel 2003)
Average of last ten rows in a list (2003)
VLOOKUP (2007)
Exclude/highlight names in a range (2003 SP2)
sumproduct with variable ranges (Excel 2003)
Close Workbook macro (Excel 2003)
WorksheetVariable/NamedRanges (Excel 2003)
Need formula help with Excel 2007
Excel Calc help needed (1.0)
MACROS (1.0)
looping for usrform (vba/excel)
SUMIFS (1.0)
Date format (excel 2003)
if value between 2 numbers... (2003)
count if formula (2000)
Format unique data into row (Excel 2003)
ado and text file... (2000)
Excel Calculation (1.0)
Chart is not lining up (2003,2007)
Use current region in dynamic named range (Excel 2003)
Password Protect Cells (2003)
can I print a split window? (XP / 2003)
lookin for data in previous worksheets (excel/vba 2003)
Excel 2000 Help (Two windows Help)
2007 vs 2003 (Excel 2007, 2003)
Reformat text data in excel (Win 2000, Excel 2002)
microsoft XPS Document Writer (XP)
zip code translate to State (MS Excel 2002 SP3)
Reverse Macro (2003)
Need Calculation to Convert Text to Number (Excel 2003)
Excel Formula (2003)
Return Month (2003)
Toggle Calculation (2003)
Parsing Data (Excel 2003 SP3)
Application OnKey (XP)
Graphing elapsed times (Excel 2003)
Deleting certain rows (2003)
Dynamic Range Average (XP)
IF - AND - OR (2003)
Pivot Tables and Drop Down Lists (MS 2003)
Cell Not Selecting (2003 SP2)
Locking a Project (2003)
Update Calendar Control (2003 SP2)
Sorting selected text on 2nd character? (Excel 1997)
precedents (exel 2000)
Copying formatted cells to the clipboard (Excel 97)
Need help correcting error's in code (excel/vba 2003)
Time event (2002)
Combining 2 SUMIF Statements (2.3)
Need excel code to extract outlook 03 display name (Excel 03)
can't fill down (Excel 2000)
Found new error, need assistance with (excel/vba 2003 )
Sorting A selection using VBA (Excel 97)
Undo - After Macro (2002)
Move to top of a column (Excel 97)
Strange Cell contents (XP/2003)
=OR( (Excel 2003)
sumif/match (2003)
EXCEL/VBA 2003 (Which is better to use?)
pivot table value and percentage (2003)
ghost on lookup (2000)
look up duplicates in column (excel/vba 2003)
reversing formula result (Excel 2003)
all info of PC (2000 sr 1)
Mail Merge from Excel
Indirect in 2007 vs 2003 (2007 vs 2003)
Conditional Formatting based on cell color (Prof. 2003)
Excel & MSQuery Parameters (Excel 2002)
ODBC problem (Excel/Access 2003)
Dynamic Range (MS Excel 2003)
Referencing Addresses (2003)
Default version (XP -2007)
Select all sheets vba (XP)
Slow Excel 2007 Startup (2007)
Using USA dates (2003 SP3)
EXCEL/VBA (2003)
Conditional Formatting - more than three options? (Excel 97)
Spreadsheet format Question (2007)
find value with 2 param (2000)
Send row to Access (2003)
Automate an Excel Chore (Excel 2003)
countif (excel 2003)
Data Merge HELP! (2007)
Formula Answer (Excel 2003)
Add Column of #'s but not all the #'s (Excel 2003)
Adding 1- at the beginning of telephone numbers (2003)
Complex Left Lookup (Excel 2003)
OFFSET/COUNTA function (MS Excel 2003)
Breaking down a dimensional string (2k7)
Time Constraints (Excel 2003)
% of colums with pivot table (2003)
Where is speech? (2007)
Excel Metadata (Excel 2003)
Find and Replace errors (2007)
Split worksheet into different tabs (2003)
Formatting (MS Office Pro 2003 SP3)
Alert Messages \ Warnings (All)
Get rid of blanks (Excel 2007)
excel/vba (2003)
month end needs to open new worksheet.. (excel / vba 2003)
Full Name Column to To Two Columns (2003)
Macro-making relative rather than absolute (2003)
Multiple Sort Criteria (XP)
Turn Horizontal Date to Vertical (Excel 2003)
Pivot Table Range (2003 and 2007)
Axis Labels On Chart (Excel 2003)
Change Text (2003)
Compare 2 Values (2003)
Sumif (2003)
Transposing Links (2003)
Data form (XP)
Getting a Count when using Autofilter (2003)
Graphs (Excel 2007)
COMBOBOX and tootip in excel userform (2000)
More than 3 Conditional Formats (Office 2003 Service Pack 2)
Translate X to Name (2003)
Password Protection (2003 SP2)
link from wbook.... (2000 sr 1)
Conditional Formatting (2003)
dlete a button in sheet.... (2000) (696050) was removed
Web query of column (2007)
Message Box (Office 2003 Service Pack 2)
Move data (XP)
formula - replacing blank with a date (2002 SP3)
SUM Formula (XP)
Function to extract Formula (2003/SP2)
Filter on Conditions (Excel 2003 SP2)
Two Dimensional lookup (Excel 2007)
Conditions (2003)
Find and Replace (excel 2003)
code not found value... (2000)
Moving Average with text value (2K3)
cell selection in one table for another (excel xp & 2003)
datevalue (excel 2007)
Find/Replace Custom Formatting (Excel 2003 and 2007)
Hyperlink problem (space or &) (Excel All)
Help with loop and chart collection (Excel 2003 and 2007)
Import Data from files (Excel 2003)
Countif's (2007)
Find First Quarter (2003)
Labels (2003 SP2 )
Pasting text into Formated Cells (Office 97 (XP Pr
formulas returning a value of nothing (Excel 2003)
If statement (2007)
Listing day in 'ddd' format (2007)
Using formulas (XP)
insert calendar into cell (XL 2007)
Amending a formula (Excel 2003 Service Pack 2)
xla running deleted vba code (excel 2003 SP2)
Sophisticated Charting (2003)
Select printer from userform (2000)
Analysis ToolPack errors after upgrade (Excel 2007)
Use count to stop macro (2000)
Automove rows to another sheet (2003)
Numbers displayed as formula (2003)
Remove number value from row (2003)
INDIRECT combined with HLOOKUP (2003)
=DAY() question (Excel 2003 SP2)
Roman Page Number (Excel 2003, SP2)
removing ' ' from varible in VBA (xls 2007)
VLOOKUP (2007)
auto computing in excel (2003 SP2)
Kick off macros (Excel2003)
Date and Time Sorts (Excel 2003 SP3)
Range Reference - Part 2 (2003)
Date (2003 SP 2)
If Statement (Excel 2003)
Cell and Range Reference (2003)
formula help - blank date (2002 SP3)
Automatically udpate links (2003)
Countif's (2007)
Userform (XP)
Return actual data in pivot (Excel 2003 / SP2)
Conditional totals on visible cells (2007)
Absolute reference (2002/2003)
Password stopping macro working (2003 SP2)
Difficulties using Vlookup/Match/Index (2000)
VBA Function to retrieve Access data (XP - 2003)
How do I access a .xla sub? (Excel All)
VBA formula (2003 SP2)
+ / - Cash on a User form (2003 SP2)
Forecasting (Win XP SP 2, Office 03)
Remove 'Sum of' (2003, SP2)
Refresh User Form (2003 SP2)
TIP: Cancel 'Update Values' in Find/Replace All
Sum all up to negative number (Excel All)
Remove 'Sum of' (XL 2003 SP2)
peraphs impossible... order line base color... (2000)
Automatic Email (2003)
Filtred line based value in combobox (2000)
why error 91..... (2000)
Creating a blank line (2003)
Convertin a texte 1 000 to 1000 (2002)
Chart printing bug (Excel 2007)
filling a blank with tha value of a cell above it
Counting dates within a quarter (2007)
Paste special to create a formula (All versions)
Reference to FrontPage (2002)
Folder location of INI file (2000+)
Find text until last occurrence (2003 SP3)
change cell color (office 2000)
multiple if statements (xp & 2003)
Save csv file as xls automatically (2003)
User Form: findind specific blank cell (2003 SP2)
Matching or indexing? (Excel 2003)
Graph Help Please (2003 SP2)
Combining Worksheet Code with Module Code (XL2003)
Sort Macro (without Range.Select) (xl03)
Save As in 2007 (Excel 2003 SP2)
Find matching combination to a value (Excel 2003)
Labels On Userforms (2000)
Return the last column address (Excel 2003)
Conditional Formatting & wild cards (2003 sp2)
Remove Alphabetic Characters (Excel 2003)
Show corresponding duplicate row number (Excel 2003)
Centering a range on the screen (2003)
Defining Value of a UserForm textbox (2003 SP)
Counting Formula Results (2003 2007)
IF AND OR help (Excel 2002)
Worksheet_Change event (Excel 2003)
Finding a wbk in a known directory (2003)
Bizarre Cut and Paste Bug (2003 sp2)
New Zoom (Excel 2003)
Move scrollbar1 (2000) (692306) was removed
Possible to compare excel files (2003)
Unlock protected sheet and then re-lock (2003 SP2)
Copy cell contents to another sheet, update change (WinXP Excel 2003)
Paste Picture on Toolbar (XL03)
formula help to update one sheet from another (2003 SP2)
Date Formula, Elapsed Y and M (XL03)
open wbook without strat coe (2000)
Pivot Grouping problem (Excel 2003)
Open a workbook to a specific worksheet (Excel 2003)
Page numbers in Excel 2000 (Page numbers)
Convert dates from Text (2003 - 2007)
Formating TextBox on User Form (2003 SP2)
dubt on var dimension... (2000)
Passwording a sheet, not workbook (2000)
UserForm:Update Sheet from 2 Combos (2003 SP2)
Public (2003)
Hidding and protecting cells with formulas (xp & 2003)
Automatic copy down (2003)