i have generated a large data set in excel (ie. the maximum ~65K lines
in excel mac 2004) using VLOOKUP.  i want to now convert this data to
values and move it into another program for analysis.  however,
everything i do leads excel to hang interminably.  can i extract the

I have a looping function that copies from a range and then pastes into
another. However I can't seem to get the function to end looping when I would
like. This is what I have to exit the loop and it does not work.
Do

is there any way to default to the "workbook" setting instead of "sheet" when
using the find function?

I have a very large excel worksheet that i would like to print just portions
of it.
how do i pick the parts i want printed and have them print on one page?
the couple of thing i tried always print each column on seperate pages.

I have a customer who wants calculations Rounded per the requirements of
ASTM E29.  Does anyone know if Microsoft Excel complies with ASTM E29 when
numbers are rounded?
Thanks

Dear Sir,
May I know how to make a date run within a cell on daily basis up to the
last day of the month using Excel formulas ?
I used =TODAY( ) , but it runs beyond at the last day of the month.

Excel 2007
Steps taken:  Created a certificate called XYZ (which I thought enable my Excel Macros)
which was placed in my Personal Certificates Store but forgot how I did that a year ago.
Now almost every previously created Excel w/s I open contains the message:

Need to summarised order/invoice data by financial period.  This Financial
Year we have 12 Financial Periods each involving the following number of
weeks: P1 = 4, P2 = 4, P3=5, P4=4, P5=4, P6=5, P7=4, P8=4, P9=5, P10=4,
P11=4, P12=5.  In MS Excel is there a way of Grouping Dates ...

i would like to make a comment on one worksheet (entire workbook is same
sheet format) and paste it to rest of workbook sheets in same cell..thanks in
advance

I made a spreadsheet and it was perfect.  However, silly user didn't see it
that way and removed a couple of columns she deemed unnecessary.
On another worksheet I had some summary data, including 12 rows representing
each month of the year, and two other columns.  Each of these ...

I'm trying to separate out some address fields (I can't use text-to-cols as
there are huge inconsistencies).
When I select a chunk of text, copy, paste, the text is truncated at the
first space.

I am trying to find the route to 'Protect Workbook in Excel2007. In previous
versions it was Tools>Protection>Protect Workbook.
I would like to protect the structure of a workbook in Excel2007.
Thank you for any guidence.

I have a problem that I cannot find solution for on any site . so .
I am using Excel 2007 and with XP2 fully up to date.
When I 'protect' a worksheet so only unlocked cells are accessable,
Ctrl+Home will not work, and neither will Ctrl+End. You can move to any of

I'm using a pivot table to analyse some data but am a bit stuck at the
moment.  I'd like to have the pivot table find, for a group, the maximum of a
column (Depth), return that value and also return the value from the same row
but from a different column (Location).

I opened excel to begina new spread sheet and the data menu is gone from
within the tools drop down menu??? I have tried to reset the tool bar but to
no avail.  I am stumped?? help?? it's infuriating.