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 / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel title bar04 Oct 2007 20:26 GMT3
I have big excel spread sheet, and the first row is the title with
username,  Ip Address, machine name
if scrow down to row 500, I lost the first row of the title bar along with
the page, is anyway when I scrow down I can have my first row of title bar
know the solution- find the operations?04 Oct 2007 20:15 GMT4
I have an old checkbook/billing issue.
I'm trying to figure a combination of billing amounts that equal an amount
that was paid.
simple terms, lets say there were vaild bills outstanding in the amount of
cross referencing04 Oct 2007 20:01 GMT1
I have a chart of accounts where an account no needs to match to a
product no.  ie 30101/100 is correct and 301010/050 is incorrect.
When preparing journals to post into our accounts program, I use a
spreadsheet.  I need a way to validate the account nos and products
simple automatic sorting04 Oct 2007 19:46 GMT11
Thanks for reading...
I have a spreadsheet with a total of 7 columns, B through H. One of the
columns, column F, contains dates. I want the spreadsheet to automatically
sort itself by sorting column F, in an order which puts the oldest date
Combo box04 Oct 2007 18:27 GMT5
I am using excel 2000. I am creating a simple data-input sheet, where the
user will be entering name, addresses, etc etc. - with each field in its own
column. I would like a column for "Job Title" where the user must choose
from a pre-determined value - e.g. Receptionist, ...
How is excel's stdev formula different from what I see in wikipedia ?04 Oct 2007 18:13 GMT6
1.  In wikipedia, the standard deviation for a population of 5, 6, 8,
9 is shown to be 1.58, which seems correct to me.
(http://en.wikipedia.org/wiki/Standard_deviation)
2.  In excel, copy paste the following data on a new sheet, and you
"Name Conflict" opening an Excel 2003 workbook04 Oct 2007 18:13 GMT7
I'm getting a "Name Conflict"  "Name cannot be the same as a built-in name."
Old name:   Print_Area
New name:
All of the solutions I've read is to load this into Excel 2003, fix the
Auditing formulas month over month04 Oct 2007 18:08 GMT4
I tried a few searched, but had no luck in finding a solution.
We have a few very complex spreadsheets, and am looking to find a way
to ensure completeness and accuracy of the spreadsheets month over
month. Currently we do the following:
hyperlink changes after save04 Oct 2007 13:37 GMT1
in office 2003 we have the problmem that when we make a hyperlink, to a
share in our nw, it works fine, but when we save the sheet, it doesn't
anymore.
Can someone help us out?
Excel file does not open04 Oct 2007 13:33 GMT3
My Excel file with the proper password does not open. If I type password,
Excel opens with top bar: Microsoft Excel - [File name] . But it looks like
standard Excel without file (blank), most funcutions in the Groups is hidden
( also Show)
Formula shows up instead of result04 Oct 2007 13:13 GMT3
EXCEL 2007
From time to time when I do a VLOOKUP between two different workbooks the
formula shows instead of the result. Sometimes if I delete the column and
insert a new one and re-do it all is ok. But there are times when nothing
Importing range of cell values from several workbooks to one04 Oct 2007 13:12 GMT2
Hello, I am new to Excel, so any help is very appreciated.
I have one workbook with 4 sheets. What I need to do is to import values
from several workbooks in that one.
I need to select the source file and import fixed range of values from that
excel file does not open when doubleclicked04 Oct 2007 12:36 GMT3
we have a user accesing office packages through terminal server. whenever he
receive an excel attachment in outlook 2003 , he cannot open it by double
clicking on it. no error message is displayed. the excel program opens with a
black sheet in the background.
New workbook/sheet defaults04 Oct 2007 11:35 GMT8
I'm using Excel 2003 and have put two files Book.xlt and Sheet.xlt in the
startup folder whose path is specified in:
Tools|Options|General|At startup open all files in:
Sheet.xlt works fine for adding new sheets and Book.xlt works fine for new
Error Validation Problem04 Oct 2007 11:03 GMT1
Can anyone help me. I have a spreadsheet I am using in Excel 2007 and
despite having checked for errors and told it to ignore errors I still
keep getting a wrning about 'one or more invalid references'. I have
unchecked the box that checks for errors in the background - but still
 
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.