| Thread | Last Post | Replies |
|
| How to activate triggers in Excel | 14 Feb 2007 17:35 GMT | 1 |
How can I setup my excel XP spreadsheet to activate triggers based on a condition that would be selected. On every open of the worksheet i would like some triggers that would display orders that are currently opened.
|
| Personal.xls notebook/file | 14 Feb 2007 15:25 GMT | 1 |
Above notebook/file unavailable on this computer. On opening Excel 2007 I am faced with Book 1, unable to open the above. On my own computer this page seems to be the default page. Any help would be appreciated.
|
| add of commandbarcontrols failed | 14 Feb 2007 00:01 GMT | 5 |
windows xp pro all updates installewd upgraded from office 2003 pro to office 2007 standard. open excel and get message Metyhod 'Add' of object 'CommadnBarControls' failed
|
| How do you change the normal template in excel? | 13 Feb 2007 20:34 GMT | 2 |
I am having problems with excel opening documents. When I go to the file that I want to open... say in my documents and I double click on the file, the program itself opens but not the document. Someone told me that my normal template may have been changed. I want to be able to ...
|
| Fixing a sheet tab | 13 Feb 2007 16:01 GMT | 1 |
For a workbook comprising many worksheets, enough that some of the sheet tabs at the bottom are not visible, is there a way to freeze the left-most sheet tab so that it isn't scrolled out of sight, that is, is always available to click on?
|
| mult. w/sheets need identical view when opening (range, mag, cell) | 12 Feb 2007 00:28 GMT | 2 |
Dear Excel Gurus, I often work with large multiple spreadsheets in a given workbook. The spreadsheets have identical structure within each book. They differ from each other only in respect of the data content of each sheet.
|
| Protected Documents | 09 Feb 2007 22:40 GMT | 5 |
i am with a client and she is trying to protect an Excel worksheet. She creates the document, clicks on protect worksheet, enters the password. if you go back you have the option to unprotect the document. But when you open the document anyone can make changes to it without the ...
|
| Status bar msg is gone | 09 Feb 2007 21:32 GMT | 5 |
I have a spreadsheet where I enable auto filtering. When I select a particular filter category, normally in the status bar, it says xx of yy records selected. But this is gone in my worksheet. If I copy the entire data set and paste it into a new worksheet in the same workbook ...
|
| change the default automatic color for gridlines and fonts | 09 Feb 2007 19:19 GMT | 1 |
How do I change the default automatic color from blue to black. Every time I start a new spreadsheet I have to change the color of the gridlines and font.
|
| can you set a default header and footer for ALL worksheets? | 08 Feb 2007 21:03 GMT | 1 |
I want to have all worksheets have the same header and footer via a default setting so that it automatically occurs - possible?
|
| Office applications will not run | 08 Feb 2007 19:44 GMT | 2 |
I am using Office XP including outlook 2002, when I attempt to run thes applications I get a message:- outlook.exe or winword.exe or excel.ex bad image followed by; DLL C:\program files\common files\microsof shared\office10\mso.dll is not a valid windows image. If I click o
|
| Data Validation | 08 Feb 2007 09:46 GMT | 2 |
Can anyone help me validate a column to allow only text and spaces. No punctuation. I used this below and was able to get only text but it also prevents spaces. =SUMPRODUCT(--(ISNUMBER(MATCH(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),ROW(INDIRECT("97:122")) ...
|
| How do I configure the default font for hyperlinks? | 08 Feb 2007 02:07 GMT | 1 |
When I create a hyperlink in a cell in Excel the cell font changes to Arial 7.5 underlined. I would rather it change to Arial 16 BOLD. Can this be configured?
|
| Global update hyperlink address | 07 Feb 2007 04:58 GMT | 1 |
A organizational change has prompted a request to re-assign a former folder on the network to a different group. The current folder "owners" heavily use hyperlinks within workbooks to other workbooks or documents. Is there a way to globally update all hyperlinks to point to a new ...
|
| How do I change settings to right-click to delete in Excel? | 05 Feb 2007 18:05 GMT | 1 |
When I want to delete a row I am forced to go to the Edit menu at the top. But how can I change this to simply right-click, then select delete?
|