| Thread | Last Post | Replies |
|
| Pivot Table Source Worksheet and Range | 31 Aug 2007 20:38 GMT | 2 |
Is there a way to view in a pivot table sheet which of the other worksheets in a workbook it derived from, and what was its original range within that raw data worksheet?
|
| Does Word have to initialize the root folders everytime? | 31 Aug 2007 20:16 GMT | 2 |
When I open Excell or Word 2007 and want to open a document, the programs spend up to 30 seconds "Initializing the root folders to display". This happens everytime I need a document. How can I avoid this. This did not happen in Office 2000.
|
| Automatic update through Web query | 31 Aug 2007 20:09 GMT | 1 |
I want the excel to retreive the data automatically from the website. For example for every 5 mins, the web query should run and retrieve the data from the website. Could some one help me on this.
|
| Getting PERSONEL.xls to open on startup | 31 Aug 2007 20:06 GMT | 3 |
I have a PERSONEL.xls file that will open on Excel startup on my computer. I attempt to put this file on other computers in the office, it will not open. I have put it in both places C:\Program Files\Microsoft Office\OFFICE11\XLSTART
|
| Running a Macro through a button vs. VBA | 31 Aug 2007 20:00 GMT | 2 |
I just created a simple macro to run in one of my workbooks. When I enter visual basic and click Run Sub/User Form, the macro works fine. However, when I create a command button, type the name of the macro in the code for the button, and then push the button, I get a Compile ...
|
| I need some help with some functions | 31 Aug 2007 19:56 GMT | 2 |
I have a column of numbers, and what I want to do is return the 7 highest of the numbers. Then, I want to be able to return the row number of each one them. The only problem I have is, if two or more of the high numbers are the same, it will keep returning the same the row number ...
|
| Tab Color | 31 Aug 2007 19:47 GMT | 3 |
Does anyone know how to change the tab color of a SHARED WORKBOOK? I am aware that some features within excel are disabled when sharing, but would like to know if this is one of them.
|
| Questions about functions | 31 Aug 2007 19:43 GMT | 11 |
I have a column of numbers, and what I want to do is return the 7 highest of the numbers. Then, I want to be able to return the row number of each one them. The only problem I have is, if two or more of the high numbers are the same, it will keep returning the same the row number ...
|
| send attachment as read only | 31 Aug 2007 18:56 GMT | 1 |
How do I send as an attachment an Excel spreadsheet as 'Read-only'? The workbook is saved in our s-drive as 'read only' but when I attach the workbook to a word document and send it (via e-mail) to colleagues they can access the workbook as normal and make changes to the data.
|
| sheet Protection | 31 Aug 2007 18:44 GMT | 2 |
Does anyone know how to allow a pulldown cell to be accessable to a user when the sheet is protected? I right clicked on the cell, deselected "lock", and then protected the sheet. But, When i tried to select an item in the pulldown cell it said it was protected and therefore ...
|
| Switched from XP to Vista | 31 Aug 2007 18:40 GMT | 1 |
Yesterday my computer crashed. Installed on it I had Office Excel 2003 and I was using Windows XP. I then purchased a new laptop that uses Windows Vista. It's already installed with a Trial "2007 Microsoft Office." Since I Already purchased the software for Excel 2003 I would ...
|
| lookup row index number | 31 Aug 2007 18:04 GMT | 2 |
I am using hlookup and vlookups and need to know how to increment the row index number. Currently I am having to count from the last row I used the formula. This creates problems when I later decide to delete rows.
|
| Copyright Question | 31 Aug 2007 18:00 GMT | 2 |
I am sorry - I know this is a tech site, but I can't find anywhere else to get my question answered - so I hoped someone could direct me. I have found where it states that MS allows an individual to offer a spreadsheet for sale...however, I can't find any information that states ...
|
| Print Areas | 31 Aug 2007 17:48 GMT | 3 |
I have a big problem somehow a 2 page spreadsheet has turned into like 500 pages. I do not know how this happened, and it won't let me change it it says "margins do not fit page page size". Any help would be greatly appreciated. Steve
|
| How to generate a list of prime number? | 31 Aug 2007 17:41 GMT | 16 |
Does anyone have any suggestions on how to generate a list of prime number in excel? such as 2,3,5,7,11,13,17,23,29,31 ... Does anyone know the formula? Thanks in advance for any suggestions
|