We had an interesting issue present itself in the last couple of days.  We
have 4 files that are password protected that are located within the same
folder.  Previously about 5-7 people were using the files and each time they
opened the file they were prompted for the password.  ...

I have a spreadsheet with hundreds of cells containing, with slight
variations, the following formula:
IF(ISERROR(VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21)),"0",VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21))
This formula is pointing towards the file name WIPSUM ...

I am trying to do this but the page keeps reverting to many pages
wide
by as many pages long.  I try dragging the page breaks but it tells
me

I have a large (about 20 sheets) workbook with lots of VLOOKUP and
INDEX functions but no macros and no links to external sources.
However i occasionally get the "File Error: Data may have been lost"
error and the same group of cells will have their formulas replaced

SORRY ABOUT MY ENGLISH
I HAVE A "B" COLUMN AND IT HAS A LOT OF ENTRIES (1100+)
AND THERE IS AN "A" COLUMN WHICH ALREADY HAS "B" COLUMN'S ENTRIES AND HAS
DIFFERENT ENTRIES FROM "B" COLUMN (150000+)

Clear Print Area doesn't seem to clear the dashed vertical and horizontal
lines that result from setting a print area.  Am I missing something?  I
know if I close and reopen the spreadsheet, these lines will no longer be
visible, but isn't there a way to clear them?

I am working with a worksheet in Excel, and one of the fields (columns) in
the worksheet is "TEAM".  I have to replicate the spreadsheet for each team,
and at the moment I am creating a copy of the spreadsheet, then using the
auto filter to filter on a team, renaming the ...

   I am trying to read the values from a excel row. There are 89
columns for each row and same number of data in each rows.
Kindly help
regards

I am charting market share of 9 companies across 13 individual
countries. I have the 13 countries on the x-axis, and %age market
share on the y-axis. Columns are all stacked to 100%.
What I would like to do is have the width of each individual column

Could anyone help me with a date comparison problem.
It can be solve with a format (I hope), or a formula (maybe), or a
macro (help)?
I explain it all into this Excel file:  http://cjoint.com/?hmv2gAKKDz

In my Excel 2007 workbook I have two sheets
The "Master Names" sheet has columns:
(A) First|(B) Last  (C) First (B) Last (concatenated)
The "Selected Names" sheet contains (A) cells which link to selected (C)

How in Excel 2007 can I use drag cells to create a weekly date column?  I
can make a number series and a days series but if I enter two Thursdays as
consecutive weeks there is no drag handle visible.
rgds,

I have a "Home" worksheet with a hyperlink to another hidden "Test"
worksheet. The test is timed and will display "STOP" in cell "u1". In the
sheet code module, I have a subroutine to recalculate so the time elapsed is
updated:

How can I make a formula calculate how many occurances of a specific time
frame happened in Sheet 1, column A, and put it in Sheet 2, column A, B, C?
Example of the colums I'm speaking of:
Sheet 1: contains start time of projects during 3 different shifts

I typed:
=countif(AND(C:C="BSM11",D:D>0,2))
why I keep getting messages like, you have not entered sufficient items or
error in formula?