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 / General Excel Questions / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
open 2000 files with 200327 Dec 2007 20:41 GMT4
We are networking between 2 computers.  Some files were created on Comp1 with
Excel 2000 and I'm trying to open and edit them on Comp2 with Excel 2003.  
How do I do this?  I can view the file name, but it just doesn't open
Creates new file when opening in windows explorer27 Dec 2007 20:23 GMT4
I have a user that has a wierd problem. When she selects an excel file in
Windows Explorer and opens it, it creates a duplicate file with number 1 at
the end. For example, if the file is called aplogs.xls, when you open it, the
file name is aplogs1. The user is getting macro ...
how to unhide multiple rows in one go?27 Dec 2007 20:06 GMT2
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do
I unhide all the rows in one work sheet in one go without having to drag them
out individually?
League age chart27 Dec 2007 19:19 GMT4
I have a large number of youth base ball players listed in a roster;
Player name        birth date
john doe              3/5/2001
mike smith         7/31/2001...
urgent help with lock excel macros!!!27 Dec 2007 19:13 GMT8
Hi to everyone,
I was looking for a way to make Excel like viewer. Surfing in the news
group I found this macro.
It works to lock Excel but now I can't unlock Excel back!!
Help! Missing information!!27 Dec 2007 18:41 GMT8
Greetings, Excel Community. I hope you can help me with this one.
I was typing some notes in an Excel Spreadsheet, which made for some really
jam-packed cells. However, when I came back to look over it, half my
information was gone, cut short at the 1.5 line mark. Is there ...
Can I restore yesterday's file?27 Dec 2007 18:29 GMT4
I accidentally replace an latest excel file to an old file... Can I restore
yesterday's file? Is there anywhere I can find that file again? :( Please
Please help... Urgent! Thank u so much
Excel 2003 - VBA - Charts27 Dec 2007 18:26 GMT1
I am beginning an effort using VBA to create a custom chart to show data
over a period of time for a select client. I realize this is going to be a
long row to hoe but I need the results that the efforts will provide.
I have done quite a bit of work with charting under VBA, but ...
Continuous data in a histogram27 Dec 2007 18:18 GMT1
I have continuous data and wish to get a histogram where the bars touch
eachother, due to the fact that in continuous data this has to occur.
However, when I have constructed a histogram the bars don't touch eachother.
Can anyone tell me how i can get the bars to touch eachother ...
Excel 2007 File Size27 Dec 2007 18:18 GMT1
I am currently working on an issue with Excel 2007. I open a file that was
previously made with Excel 2003 and was only 1.7 MB but when I opened the
file in Excel 2007 and clicked save the files size jumped to 2.43 MB. Now
that I have done that when I try to open the file it ...
Excel 97 Find and Replace27 Dec 2007 17:58 GMT1
Have the following issue:
Column of telephone numbers are listed as follows:
### #######
Is there a way using find and replace to delete the space between the
Sumproduct Help27 Dec 2007 17:36 GMT2
=SUMPRODUCT(--('Consolidated Exp'!$E$2:$E$5000=C$9),--('Consolidated
Exp'!$K$2:$K$5000=("I")),'Consolidated Exp'!$F$2:$F$5000)
coulum E = Month,
coulum K = Type of expense
Pivot table Calculated Field27 Dec 2007 17:35 GMT1
I have a column of Salesmen together with an associated column of their sales.
Let's say that the total of all the sales is £100,000.
I would like to insert a calculated field that shows the % contribution that
each salesman makes to the total sales.
Pivot tables - All Change with Validation List27 Dec 2007 17:33 GMT1
I have an Excel workbook with several sheets in it.  I have the following
sheets:
Summary
Totals
countif formula: 2nd column qualifier27 Dec 2007 17:21 GMT6
In column C, I have a lead source, ie Bid, Yellow Pages, Website etc.  In
column G, I have Sold, Open, Lost.  I have tried to come up with a nestled
function that counts the instances of sold in column G for each source in C,
but with no luck.  Any help?
 
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.