| Thread | Last Post | Replies |
|
| HELP: can no longer open protected file in XP | 19 Jul 2006 16:02 GMT | 1 |
All, I have a 1.3 meg spreadsheet file in excel (office XP suite). I used the password protection feature to keep others who share my PC from being able to open the file at will. Worked fine for a few weeks.
|
| Working with excel on the web | 19 Jul 2006 15:34 GMT | 2 |
I am looking for a possible solution or bump in the right direction when working with excel on the web. Currently I am using and developing in visual studio 2005. Here is the situation I have a lot of spreadsheets with macros that I would like to deliver to people via a
|
| highlight an entire row if a date in one column falls between a given range | 19 Jul 2006 14:29 GMT | 1 |
Apparently Iposted this on the wrong newsgroup, so I'm reposting here. I would like to know if there is a macro that automaticalle highlights an entire row if a date located in one column falls between a given range:
|
| Coloring a Cell | 19 Jul 2006 14:18 GMT | 3 |
Is there any way to make a cell turn a different color when the value in it is something? I have a bunch of scores being calculated and I want anything lowed than 80% to be tunred yellow and anything below 60% to be turned red. I have some programming knowledge and I'm willing to
|
| How to change an existing query | 19 Jul 2006 13:34 GMT | 2 |
I have been using excel more than a year. I have a tool that contains a query in one of the sheets which will coonect to an oracle database and retrieves the data. Now I have to change the query. Is this possible for me change only the query with out disturbing the other
|
| Repeating Cell Entries Between Sheets | 19 Jul 2006 13:18 GMT | 9 |
I have eight sheets in a workbook and want to repeat an entry in a cell from one sheet to another. For example in sheet/cell Carl-Summary L3 I type the figure 60. In sheet Main Summary I want this figure to repeat in cell C6 and so on.
|
| Excel to Access - formula does not work... | 19 Jul 2006 12:08 GMT | 1 |
I have the following working formula in excel and it works but when import the excel file into Access it does not work at all. I am trying to put it in either a query or a table in Access. B C D E F
|
| graphs - adding axis and title | 19 Jul 2006 11:33 GMT | 1 |
don't know if anyone can help but... I am working on creating KPI's and I have one for which the graph was already generated from the spreadsheet (sorry if my excel jargon is off - I work in France and know this better in French than English!). The Y axis exists and has a
|
| How to copy a row with transposing to a column retaining links to input cells? | 19 Jul 2006 10:09 GMT | 2 |
How to copy a row with transposing to a column retaining links to input cells? Excel transposes with a links change or only values. Best regards, Dima
|
| How to get Value Cells for Sheets name | 19 Jul 2006 02:37 GMT | 1 |
with many sheet, i don't know before, it depends on files how to get value of $cell that named for that sheet ths for helping. best wish.
|
| Create a new Excel file with selected cells | 19 Jul 2006 01:31 GMT | 1 |
I need your help once again. I have a Dashboard with five sheets and I was wondering if there is a function to create a new Excel file based on the data selected from the Dashboard. I would like to select data or cells from different sheets from the
|
| export from Access to Excel has created problems with | 19 Jul 2006 01:05 GMT | 3 |
I am a new user with vision impairment, so it is extremely likely that I missed the help that has already been offered. For that I apologize and thank you for your input. I was working on a database in Access, but was having a problem because of
|
| Counting and colour coding ranges of occurances | 19 Jul 2006 00:38 GMT | 4 |
a have a list of employee ID numbers and need to count how many times they occur withing certain ranges. For example: if one occurs between 5-10 times I want all occurances highlighted in yellow, if it occurs between 10-15 times I want all occurances highlighted in blue, and if ...
|
| Comments. | 18 Jul 2006 23:17 GMT | 6 |
I have two workbooks which have comments on a few of their cells. As is appropriate, when I point to each of those cells the comments they contain appear alongside. But often (not always), after I have saved the workbook then opened it
|
| "Remotely" Change Cell Values | 18 Jul 2006 22:46 GMT | 3 |
Hey gang - I've developed a deer population model (1 for each of 88 counties) to track herd size from 1981 to present. I start with an initial population estimate (in 3 male and 3 female age groups) in 1981 and
|