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 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I get Office 2007 to show me the full path of a file?28 Mar 2007 18:37 GMT2
In previous versions of Microsoft Office you could have the name of the
current file and it's full path appear at the top of the screen.  Now, with
Office 2007 all I can get is the file name.  How do I get it to show the full
path?
Saving As .CSV28 Mar 2007 18:10 GMT9
Hello, here's the situation: I downloaded an .xls file from my broker and
opened it in Excel.  The original file was delimited by commas and I had to
choose comma delimited in order for Excel to display it in columns/rows
correctly.  I made some changes to the file, then saved it ...
Cond. Formatting Trouble28 Mar 2007 16:45 GMT1
I have a spreadsheet with cells that have conditional formatting to
turn a certain color based on the input value.  Its been working fine,
until the last few times it has not changed the color of the cell
until I close and reopen the sheet.  Why might this be?
image send to bak28 Mar 2007 16:26 GMT1
i inset a picture in my sheet  and i can not see the cell i want see the
cells and put this picture back of the cells what must i do
thanks
Rows of data, using status columns to sort data to pie chart on another worksheet tab28 Mar 2007 16:05 GMT1
1.  I have 50 rows of data.  There are many columns, but, there is one
status column that I use to group the rows of data into
relationships.   I would like to build individual charts based on the
status column.  So, if I say these items are part of "Group A",
Show Excel in two separate instances/two monitors?28 Mar 2007 15:49 GMT10
I've recently been upgraded to two monitors (one of the few things IT
has done right around here!).  But try as I might, I can't get two
Excel (2003) workbooks to show in two separate instances so I can put
one on each monitor!  Any solutions?
Which is faster sum(if) as an array or sumproduct?28 Mar 2007 15:28 GMT3
I finally got my sum(if) based on more than one condition to work but it
takes my 1.8 Ghz chip 7 or 10 minutes to calculate the workbook with the
array formulas in 2003 Excel. Is Sumproduct any faster or do I just need to
use the free time to do something else?
Sensitivity analysis28 Mar 2007 15:26 GMT1
I have a worksheet calcuating some results driven by different parameters.
Is there a way I can tabulated (probably in a separate worksheet) the
different results against different tuples of parameter automatically or
easily?
charts28 Mar 2007 14:54 GMT2
What is the best chart to show how much a different person used each year.
Each person represent a different house I want to show which house used the
most services for the year.  So in excel I have a list of the people and the
services they used on specific dates and the amount ...
Silly question?28 Mar 2007 13:30 GMT5
Silly question?
Just as one can sort a range up or down by this or that column, can one sort
a range this way or that way by this or that row?
I see no way of doing this but need to sort a schedule in this way as part
Calculating number of weeks between dates (start and end dates)28 Mar 2007 13:13 GMT1
Two things I would like to do and I presume that Excel is the software to do
it:
1.  Ability to calculate the number of weeks between two dates.  For example
how many weeks betweeen April 2, 2007 and August 31, 2007.
Grouping and Protection28 Mar 2007 13:09 GMT1
I need to use grouping on a spreadsheet (Excel 2003). Having designed the
spreadsheet which uses grouping I then want to protect it but in doing so it
stops users showing and hiding the groups.
I have tried variuos options within the protect sheet dialog box but to no
How to copy a Macro to another PC28 Mar 2007 12:56 GMT1
How can I find and copy an Excel macro to another PC.  As I recall the one I
created also created a file called Personal.xls that automatically opens up.  
Not sure if this is the only file that needs to be copied?  Also, where does
it get copied to?  What location?  Same as ...
test if data fits between two columns28 Mar 2007 09:41 GMT9
have a table that I insert measured data into.  Based on the value
of the measured data, a formula returns a value in an adjacent cell.
Usualy this would be easy for me just using a simple IF function But
my method creates too many ifs and I get an error:
copy reference number28 Mar 2007 04:34 GMT2
I have created a large spreadsheet
Some 30000 Items
I wsh to add a field for MYREference number at the end of each line
for example badtimes1 then I would like to be able to automatically copy
 
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.