| Thread | Last Post | Replies |
|
| Formating number in Excel | 31 Aug 2007 17:31 GMT | 2 |
How do you change format so invoice number changes each time?
|
| find and replace inside comments? | 31 Aug 2007 17:12 GMT | 3 |
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 constant | 31 Aug 2007 16:54 GMT | 2 |
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 GMT | 7 |
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 file | 31 Aug 2007 16:30 GMT | 8 |
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 text | 31 Aug 2007 16:26 GMT | 1 |
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 mode | 31 Aug 2007 16:12 GMT | 5 |
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 formatting | 31 Aug 2007 15:58 GMT | 9 |
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 text | 31 Aug 2007 15:50 GMT | 6 |
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 worksheet | 31 Aug 2007 15:46 GMT | 2 |
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 GMT | 1 |
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 workbook | 31 Aug 2007 15:36 GMT | 2 |
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 Problem | 31 Aug 2007 15:25 GMT | 2 |
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 saved | 31 Aug 2007 14:56 GMT | 1 |
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 Second | 31 Aug 2007 14:36 GMT | 5 |
Total time was 32 hours 19 minutes 31 seconds. How can I determine the number of objects per second?
|