Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
WebData Substitute06 Mar 2008 15:04 GMT2
Folks:
Excel 2007 has an add-on called WebData. Essentially it can use any web page
as a data source and download content to the spreadsheet.
 *  Is there any software program out there than can be used to perform the
excel changes my figures06 Mar 2008 14:53 GMT1
hi I tryed to inpit this info into a chart
0.008199    6.3
0.0151625    6.8
0.006469    7.5
SORTING BETWEEN WORKSHEETS06 Mar 2008 14:37 GMT11
I HAVE THREE COLUMN ON SHEET1 NAMED AND LOOK LIKE THE BELOW:
A1            B1              C1
NAME    START     END
A                9 AM    5 PM
Round up or down to a multiple of 506 Mar 2008 13:45 GMT5
I have a question. Im trying to come up with a formula that should say:
the total of a whole number times 1.15 and then round it off to either a 0 or
a 5.
Can someone please help me!
Can I mark a point on curve?06 Mar 2008 07:45 GMT1
I want to mark a point in curve of chart.
it is possible?
Data Validation against table list06 Mar 2008 05:27 GMT1
Hi, I've got some Excel tables in a spreadsheet and I'd like to add
data validation to some other cells so that only those values in the
table can be chosen.  I know how to do that where the list of choices
comes from a named range, but Excel won't let me refer to the table
display changing label caption on form as sub runs w/o screen flic06 Mar 2008 03:02 GMT1
let's say i have this routine
Sub Test
   label1.caption = "Starting ... "
    'do  events
Autofilling formulas when I insert a row05 Mar 2008 23:26 GMT2
I've got a rather complex Excel 2007 spreadsheet that others are going
to be editing, and when they insert rows I would like to have the
columns with formulas in them fill down to the new row.
I know there's a setting in Options to Extend Date Range Formats and
trouble getting a formula to repeat rows05 Mar 2008 22:39 GMT5
Thanks in advance to all your help.  
I have a formula I'm using, =(C1*3)+(E1*5)+(F1*3)+(I1*5)+K1, and I need it
to repeat at the end of every row and recalculate every row, so that every
row has its own total.  Trouble is, when I copy the formula from the Formula
Poor performance in Excel 200705 Mar 2008 22:27 GMT7
I am facing a very poor performance in Excel 2007. Some files I have (around
2.5 Mb each one) take almost 1 minute to open/close in Excel 2007, while in
Excel 2002 the same files take no more than 2-3 seconds.
Any idea?
Excel 2007 File type conversion05 Mar 2008 21:32 GMT1
Is there a way to convert a work sheet to an xml document?
Thanks in advance
COUNTA formula with indirect reference - help please!05 Mar 2008 19:46 GMT7
Hi--
I am getting strange results with a formula. I would like to use
COUNTA to count non blanks in a worksheet called "Data".  I'd like it
to take column values from cells C2 and D2 to get the range of data in
I type a word in a cell, tab out and it changes05 Mar 2008 19:38 GMT1
For our invoicing we use the same worksheet every time, we just type in the
new information, print the invoice off and so on.  I came back into work
today and now when I type a certain word in any cell, as soon as I tab out of
that cell another word appears.  I cannot figure out ...
counting nonblank rows05 Mar 2008 18:46 GMT8
I'm trying to figure out how to integrate the number of nonblank rows within
a given array into my formula.  I have tried COUNTA(ROWS(C6:Z29),1), but that
does not give the correct result.  Any help that you all may offer would be
greatly appreciated.
Excel 2007: Flaky Macro05 Mar 2008 18:35 GMT2
I've got a weird situation with a macro that I'm not sure how to go about debugging. This is all within Excel 2007.
From time to time (i.e., not always), the macro fails at a point where I first load a workbook and then immediately save it as an
Excel 2003 file. And it fails by ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.