I have a spreadsheet that does a Data/Import External Data/Web Query to get
data from my Yahoo stock portfolio.  It has worked for years.  On January 31,
Yahoo made a change to their web page and my query stopped working with the
following message:  "Unable to open http://finance ...

Hello.  I'm a 1-2-3 user who is trying to become familiar with Excel.  I
have a very basic question, and would appreciate any help from
experienced users.
In 1-2-3, if one opens a sheet and enters "4*5" the cell will show "20".

Office 2003, Win XP sp 2
I have a large excel spreadsheet, and every once in a while when I try to
save it, it states "document wont save". I have tried saving to different
places, on the netowrk, local hd, etc. If I close it, and loose all my

I recently scanned a number of newspaper articles and saved them as PDF
files using this as filename: article_newspaperddmmyy
e.g. Big story_FreePress050206  where 050206 refers to February 5, 2006.  I
have a folder with over 300 filenames like that. I used a PrintFolder

I need to capture the "Send this sheet" button click event to override its
functionality. "Send this Sheet" can be found on opening File -> Send To ->
Mail Recepient.
It can also be found using  ActiveWorkbook.EnvelopeVisible = True in VBA.

I need prepare full list with numbers, starting from 129680  and up to
129779 (in some column):
129680
129681

OK
I have a list of items starting in A1 down to A?, I have the associate
costs of those items in Column B1 down to B?, and the quantity of thos
items ordered starting in C1 down to C?.  What I need is a formula tha

Hello I have a slight problem, I want to do the following:
A1 has 25   ,  B1 has 55   and in C1 i put the formula  =B1/A1  which i
get 2.2, how can i put in C1   2   and then on C2    0.2 ...which is the
remainder?

Hi I would like to know if there is a command to deselect "allow cells drag
and drop" check box, and how to integrate it on to a macro every time a file
is open.

I'm trying to put the contents  of an excel document into a
HTML/PHP/ASP page. But what I'm trying to achieve is when the exce
document gets changed I would also like it to change in th
HTML/ASP/PHP document.

in my pivot table while i am trying to add field names in the data area
i am getting only the "count" and not the "sum". but my target is only
the "sum"?of course..the filed is formatted as number!
what's wrong with me?

      £      -  $            -   C$          -
Hi All Guru's out there I do not know if this is a silly question or not but
here goes
I want to set up a spreadsheet proforma whereby i can total all the amounts

Hello.  I'm a 1-2-3 user who is trying to become familiar with Excel.  I
have a very basic question, and would appreciate any help from
experienced users.
In 1-2-3, if one opens a sheet and enters "4*5" the cell will show "20".

If i have a list of numbers say in cells c1 to c10 and i have a sum to
add these all together and display the answer in c11. I want to be able
to only allow the cells (c1 to c10) which have been allowed to be part
of the sum by entering a figure in d1 to d10 i.e if  c2 contains £20 ...

How do I set up monthly/yearly expence sheet by vendors? Do I have to yuse
excel or any other program? Thanks a lot for the help!