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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formating number in Excel31 Aug 2007 17:31 GMT2
How do you change format so invoice number changes each time?
find and replace inside comments?31 Aug 2007 17:12 GMT3
I have a large range of cells that contain comments.  I want to change the
word linear to exponential in all the comments.  Is there a way to do this?
cell currently being evaluated contains a constant31 Aug 2007 16:54 GMT2
I'm using Excel 2003 Prof Ed.  and am experiencing a similar problem as
described in previous posts, but can't find a solution.  The formula works in
some cells but not in others.  I have tried changing the format of the cell
and checking the formula, but excel does not even want ...
Fastest way to select large range (e.g. B3:F1002)?31 Aug 2007 16:36 GMT7
What's the fastest way to select very large ranges, for example the 5-
by-1000 range B3:F1002?
I know I can select B3, scroll or page down to row 1002, and shift-
left-click on F1002.
Last modified date of a linked file31 Aug 2007 16:30 GMT8
I've seen several posts on how to display last saved date for the active
workbook, but  I'm searching for the last saved date of a linked file. Can
anyone suggest a way to use BuiltInDocumentProperties with a reference to the
another file?
Return cell reference as text31 Aug 2007 16:26 GMT1
Looking for a formula that will allow me to return a reference used in
another cell as text.
For example
cell tab1!A1 contains formula =tab2!c1 and displays contents of tab2!c1
full screen mode31 Aug 2007 16:12 GMT5
When I go into full screen mode I can't seem to get out of it.  There is no
full screen toolbar on the top.  How do I access this, thanks?
Using + and / as characters not as functional formatting31 Aug 2007 15:58 GMT9
I want to use + and / symbols as text (in a table to designate positive or
negative evaluation), but formatting all cells in the document as 'text' does
not keep Excel from recognizing them as computing functions.  Here is the
weird part.  If I copy and paste a + or / character ...
Show cell reference as text31 Aug 2007 15:50 GMT6
How can I show a cell reference as a text?  For example, if cell A1 contains
the formula =worksheet1!A1, it will return the contents of the cell
referenced.  In a different cell, I'd like to show the text "=worksheet1!A1".
More specifically, I'd like to be able to extract the ...
Formula to extract data from other worksheet31 Aug 2007 15:46 GMT2
My problem is this. The following formula:
=(('Budget MRS 2007'!$H6*'Budget MRS 2007'!$H7)+('Budget MRS
2007'!$I6*'Budget MRS 2007'!$I7)+('Budget MRS 2007'!$J6*'Budget MRS
2007'!$J7)+('Budget MRS 2007'!$K6*'Budget MRS 2007'!$K7)+('Budget MRS
How to update edited values in validation list?31 Aug 2007 15:37 GMT1
I am having problems with my validation list when I have updated the
source data for my validation list.
Example:
In [A4, A8] I have a list of 5 book-titles (e.g. A4 = "TrueStory").
Macro linking to wrong workbook31 Aug 2007 15:36 GMT2
I have a monthly process where each month I get a new report. In order
to calculate the numbers I need, I open the prior month file and copy
the tabs lookups / pivots I need.
I have macros stored within those tabs to update the pivots and run
VBA Problem31 Aug 2007 15:25 GMT2
i am new in VBA i made a user form and want the form show when i open the
workbook i put code below but it doesn't work please help.
Private Sub Workbook_Open()
   InvFrm.Show
Changes to workbook not saved31 Aug 2007 14:56 GMT1
I have a problem.
I have an Excel 2003 workbook on a network that is constantly being accessed
by different people. It's a master copy that's supposed to have its changes
saved every time someone's done with it, but the problem is that it doesn't.
Calculating Objects Per Second31 Aug 2007 14:36 GMT5
Total time was 32 hours 19 minutes 31 seconds. How can I determine the number
of objects per second?
 
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.