| Thread | Last Post | Replies |
|
| Prevent formula entry | 22 Jun 2007 04:42 GMT | 4 |
I have a workbook which I want to prevent users from entering formulae globally across the entire workbook. There are however formuale already entered into the workbook but want to prevent any new formulae being entered.
|
| Unable to use right-click on cells; standard and formatting toolbars disabled | 22 Jun 2007 04:17 GMT | 3 |
I'm not sure what happened but a while back I started having problems with excel. First, the Standard and Formatting toolbars are no longer displaying in the toolbar area. When I use Customize toolbar they appear on the
|
| Opening new instances of Excel | 22 Jun 2007 03:49 GMT | 3 |
If I open multiple xls files, they're all in the same window. How can I open multiple windows so I can have them side-by-side to see information on two or more sheets simultaneously? Thanks,
|
| Division amidst aggregation macro? | 22 Jun 2007 03:12 GMT | 1 |
I am aggregating data from multiple workbooks into one workbook. Due to the way some of the data is formatted, I want to divide one of the metrics by 100 prior to the macro pasting it into the aggregated workbook.
|
| Text boxes disappear on Excel Chart | 22 Jun 2007 02:33 GMT | 1 |
With Excel 2003 I'm trying to print a Chart with text boxes on it (some are text comments and others are data values). I'm getting an unusual result. If I select the chart, the text boxes with data values in them disappear and will not print, but the text boxes
|
| Text box function is disabled ... | 22 Jun 2007 00:57 GMT | 4 |
OK, I'm embarrassed ... I posted about this two days ago and despite an hour's worth of efforts, cannot find the thread. I have an Excel document in Vista (though it has been saved to be compatible with Office 2003) with text boxes. I am unable to select a text box to move it, ...
|
| Excel Macro - Htm file to Body of Email Error | 22 Jun 2007 00:33 GMT | 1 |
I posted this over on programming but I didn't get a response to it over there, so sorry for the semi double post: Here is the code I'm working with: Sub SendEmail()
|
| Filling formula using macro | 21 Jun 2007 23:20 GMT | 1 |
My excel file is having 2 worksheets. Sheet 1: is blank Sheet 2: first 3 columns of the first row is having formula. I will paste few rows in the first sheet. Can i have a macro, which
|
| Formulas | 21 Jun 2007 22:25 GMT | 2 |
When I put in a formula for a total, how do I make it show up as blank instead of a zero if there is only one variable listed. For example, I want to put a mileage rate in as a constant and I want the total cell to be blank instead of zero if there is no mileage number in the ...
|
| dynamic charts | 21 Jun 2007 21:52 GMT | 2 |
I have a series of monthly reports within excel. Each of those reports has a raw data tab. The raw data goes from left to right and each column represents an additional month. The rows represent different metrics that are tracked over time.
|
| Excel text corrupting problem | 21 Jun 2007 21:31 GMT | 4 |
Has anyone seen anythink like what is happening in the Excel screenshot below .. http://www.jon-lamb.co.uk/tf_excel.gif The text is corrupting in cells. Its just happening on one PC and in
|
| Duplicate Range names | 21 Jun 2007 21:06 GMT | 2 |
Suppose I have Sheet1 containing a named range, "Something". If I copy to a new sheet (Edit | Move or Copy Sheet), the new sheet also contains "Something", and I can reference either one (Sheet1.Something or Sheet2.Something). So far so good.
|
| Auto numbering | 21 Jun 2007 20:24 GMT | 1 |
Wish to use auto numbering system for test sheets, i.e., every time I open my test sheet, a cell with a number in automatically increments, is this possible in excel? Regards
|
| Number Formating | 21 Jun 2007 19:05 GMT | 1 |
For some reason, everytime i am typing a number in excel, the last two digits are made into decimal. For example, if I type "1,023" into a cell, once i hit enter it becomes "10.23" in the cell. How do I fix this? Thanks
|
| Excel - Visual Basic (Compile Errors) | 21 Jun 2007 18:28 GMT | 2 |
I have a couple of issues and I'm not sure from where they're rooted. I've been trying to install Adobe CS3 with issues. I'm not sure how that relates other than there was a flashpaper addin at one time and I had problems with it not going away in excel. Now it's gone from excel ...
|