| Thread | Last Post | Replies |
|
| Data Transfer | 30 May 2008 16:33 GMT | 5 |
Is it possible for Excel to transfer data from one workbook to specific cells in another workbook. I am using Office Home and Student 2007, do I need any extra software?
|
| ActiveX | 30 May 2008 16:09 GMT | 3 |
Every now and then I get this message: ‘Your current security settings prohibit running ActiveX controls on this page. As a result the page mat not display properly” How can I fix this?.
|
| Get a text in for specific day sumproduct / dget | 30 May 2008 16:03 GMT | 1 |
I have a large worksheet with contact details and booking areas (Booking 1, Booking 2 etc.): Booking 1 Booking 2
|
| I want to Autoformat in Excel - like Word. How? | 30 May 2008 15:45 GMT | 1 |
Specifically, I want to replace straight quotes with smart quotes.
|
| filter and save result | 30 May 2008 15:29 GMT | 4 |
After filtering a list, how do I save only the filtered result "as it is shown" on the same worksheet and discard the rest? Please help...thanks.
|
| changing signs in formulas and cells | 30 May 2008 15:28 GMT | 1 |
I have a range of cells (A1:H100) containing a mixture of entries:- a) cells containing formulae eg: =23-4+6 (plus and minus only - no multiply or divide) b) cells containing single positive amounts eg 705 (ie no sign)
|
| Excel hanging... | 30 May 2008 15:13 GMT | 1 |
This is a strange one. If I double click on a saved Excel 2003 workbook (saved on my desktop), it takes ages to open and then will hang. If I open Excel then select the workbook, it loads immediately. Has anyone any ideas on this one?
|
| Hyperlink on Websites Addresses | 30 May 2008 15:12 GMT | 2 |
This question has been asked in previous posts, but not specifically responded to WEBSITES. Scenario : worksheet with Websites links pasted going from A1 to A300.
|
| averaging with a filter | 30 May 2008 15:10 GMT | 1 |
i would like my average of a group of numbers to change when I filter the numbers in other columns. thanks alot
|
| "Send To" Missing From File Menu | 30 May 2008 14:52 GMT | 4 |
Good Afternoon All, I have a user who has Excel 2003 SP3 and her "Send To" is missing from her File Menu. I attempted to Add the "Send (as Attachment)" to her File Menu and it is disabled. We are a Lotus Notes house and Lotus is her default mail
|
| List Box - Change Font | 30 May 2008 14:50 GMT | 4 |
Can I change the font of the display in a drop down box?
|
| Original Pivot Table Defaul Format | 30 May 2008 14:47 GMT | 2 |
When messing around with my table options recently, I inadvertently eliminated the default pivot table formatting recently and can't retrieve it. I've tried using the format report option and selecting "Pivot Table Classic" (which is not the classic format BTW). No dice. I tried ...
|
| excel won't automatically open attached email excel files? | 30 May 2008 14:37 GMT | 1 |
office 2007 has worked for 2 wks and mysteriously today, it won't open excel attachments in emails I receive. I get an error msge that says it can't find the file.
|
| Referring to Cells | 30 May 2008 14:37 GMT | 4 |
I have two workbooks open in Excel 2003. From WorkbookA I need to get the currrent row number, add 1 to it and copy the contents from WorkbookA to WorkbookB. Presently I have the following code that works... Dim CurrentRow as Integer
|
| is it possible to reference a tab name within a cell by formula? | 30 May 2008 14:18 GMT | 1 |
I know I can show the tab name in the footer on a document when I print it, but is there anyway of showing what the tab name is within the worksheet itself on the screen?
|