| Thread | Last Post | Replies |
|
| Macro to unprotect with password | 29 Sep 2006 00:30 GMT | 1 |
Hi Excel People I need a macro that when pressed asks for the passwork to unprotect a cell/worsheet. If possible i would then like another input box asking for a number
|
| Problem with Hyperlinks in Excel 2003 | 28 Sep 2006 21:05 GMT | 1 |
Recently my company has moved to office professional 2003. Since the upgrade, I have experience 2 PC’s with the same issue. That is, opening any new excel file, adding say http://www.microsoft.com to one of the cells and then trying to click the hyperlink to view the http
|
| Chart Question | 28 Sep 2006 20:59 GMT | 2 |
is it possible to create a chart, skipping columns or rows I need to creat a chart using data from every other column and another using data from about every 5th row Any help appreciated
|
| Not Enough System Resources... When Opening Excel | 28 Sep 2006 19:35 GMT | 1 |
One of my users has just started getting this error when she opens Excel: Not enought system resources to display completely. She is opening Excel, not an Excel file, ie: new worksheet. This is on XP with SP2 and all updates
|
| vba sourcecode to convert pdf to xls | 28 Sep 2006 19:14 GMT | 2 |
Does anybody know a home page where an example of a vba source code is listed, which enables to convert a pdf file (with tables) into an xls file. I would need some ideas how to do this, in order to write my one little
|
| Why is the sort command in excel 2003 shaded out? | 28 Sep 2006 18:05 GMT | 7 |
suddenly Excel stopped letting me sort rows. No matter what I try, I cannot get the sort command and icon to be usable.
|
| Way to combine 2 cells? | 28 Sep 2006 17:52 GMT | 3 |
I have the following A B C... I Budgeting I1 cccc
|
| how to | 28 Sep 2006 17:18 GMT | 1 |
Here's the scenario, I have to accumulate hours and days that I work. I am only paid a day rate. yet sometimes I work an hour here and an hour there. When I reach a certain number of hours, I have to bill for a full day rate. Is there a way to keep a running total and when it ...
|
| Will excel 2003 format a cell to the year? | 28 Sep 2006 16:49 GMT | 1 |
It seems like it should be obvious, but I am finding it impossible to get excel to do a date format that recognizes a year. Is there some way?
|
| Protected Worksheets and Comments | 28 Sep 2006 16:00 GMT | 1 |
I would like to be able to be able to add comments to a protected worksheet. I am using Excel 2007 Beta. When I "protect" the sheet, I do the following... Yes = Select locked cells
|
| transpose columns into rows--with a twist | 28 Sep 2006 15:39 GMT | 3 |
I've got two columns. Column A contains the ID; column B contains a list of subjects, delimited by comma. For example: HappyValley A,B,C,D,E,F What I'd like to do is to break up the list in column B using
|
| Migrating from Excel 2002 to Excel 2003 | 28 Sep 2006 13:51 GMT | 1 |
Our company is finally moving from Office 2002 (Excel) to Office 2003 (Excel) and I am wondering if there will be any problems, issues using Excel 2003 from files created from Excel 2002. I don't think so unless an Active X is embedded in a marco or in the actual file. Any tips ...
|
| Toolbars hide where? | 28 Sep 2006 13:48 GMT | 6 |
Apologies, I've not kept a note of when you told me before - where do XL toolbars and their custom buttons hide? Universal macros are in PERSONAL residing in Application Data\Microsoft\Excel\XLSTART\
|
| Filling one cell only if another is filled | 28 Sep 2006 11:16 GMT | 2 |
Bare with me if I don't get the terms right.. my excel isn't in english :-) I am in need of a funktion, which I am quite sure I have done before... when the dinosaurs roamed, which is why I can't remember how
|
| Speeding up Excel - Large amounts of data, no complex formulas | 28 Sep 2006 11:03 GMT | 3 |
I am currently investigating what is the most cost effective way of speeding up excels calculations for large spreadsheets. The sheets do not contain what I would consider to be overely complex formulas with the main tools being VLOOKUP, with maybe a few nested IF statements.
|