| General Excel Questions (view all ...) | Last Post | Replies |
|
| Moving around in the Worksheet is difficult | 09 May 2008 16:08 GMT | 3 |
I have a workbook that I can't use the arrow buttons on the keyboard to move
around in. I can only use the mouse to select cells, only after the workbook
unfreezes and allows it. I don't know what is going on here.
Any ideas?
|
| how can I analyze volatility in excel | 09 May 2008 16:03 GMT | 1 |
Is there a function in excel 2003 which compute volatility in a given data.
|
| using 'paste link' into seperate tab | 09 May 2008 16:01 GMT | 4 |
I have a parent spreadsheet in tab 1 and on seperate tabs I have chunks of
the information through paste special and paste link. When the parent cell
is empty, the paste link command is putting a zero in instead of leaving it
blank. This is messing up my averages. I have tried ...
|
| Calculating bonuses - but not a VLOOKUP or CEILING? | 09 May 2008 15:59 GMT | 6 |
I have a big PivotTable of sales of specific products against
salespeople.
Product Salesperson1 Salesperson2
product1 1 5
|
|
| New Users (view all ...) | Last Post | Replies |
|
| Sharing | 09 May 2008 16:09 GMT | 1 |
Is it possible to share an excel worksheet - have two users make corrections
at the same time?
|
| Conditional colours in Lookup table | 09 May 2008 16:01 GMT | - |
I have a table that reports results from a lookup table.
The results are in column "L"
I am wanting specifics to be highlighted.
If a cell reports "sam" or "jim" to be blue etc.
|
| How do I use the autofilter to sort a list | 09 May 2008 15:35 GMT | 2 |
How do I use the autofilter to sort a list
|
| Excel is giving me zeros | 09 May 2008 15:26 GMT | 2 |
Excel is giving me zeros. I'll put in a formula that very obviously
should give a non-zero result, but the cell says "0". I tried
different simple formulas, even just “=f8+f9”, but the result is 0.
The source cells have numbers entered into them. I checked formatting
|
|
| Excel Errors (view all ...) | Last Post | Replies |
|
| Excel won't Calculate | 09 May 2008 10:06 GMT | - |
We have rolled out Office 2007 across the company, and this week I have had
two users with the same problem.
The have a calculation in a cell that the copy down. The formula is correct
right down the column, i.e. A1+B1 goes to A2+B2 etc... but the value all the
|
| Cannot open Excel file | 09 May 2008 03:11 GMT | - |
Running Office 2007 on Windows Vista for a long time, no problem. Today, out
of the suddenly, Excel files stopped being open when I double-click the file.
I can only open Excel file from whithin Excel program using the option
"Open". Already repaired Office, unistalled and ...
|
| Error setting pivot table CurrentPage to nonexistent value | 08 May 2008 22:47 GMT | - |
I have an Excel 2003 pivot table with 4 page fields. In a macro I set the
CurrentPage property of one or more of these fields to certain fixed values
and attempt to retrieve data. Everything works fine until I try a value that
doesn't exist for a page field, upon which I get a ...
|
| File beyond Repair | 08 May 2008 21:18 GMT | 2 |
I have had several s/sheets that when I try to reopen after saving(without
any error message) they become so corrupted that they are beyond repair
losing all formulas OLAP tables and formats.
This happened today with a s/sheet I had opened and closed several times
|
|
| Worksheet Functions (view all ...) | Last Post | Replies |
|
| copy cell with macro and increment down each time | 09 May 2008 16:10 GMT | 2 |
I need to create a macro that copies two adjacent cells A148 & B148 (same
cells each time but with a different value each time) and pastes them into
another column but moving down one row each time. The object is to retain the
previous values ultimately resulting in a column of ...
|
| Multiple functions in one cell | 09 May 2008 16:04 GMT | 4 |
Is there a way to write a formula that will leave a cell blank if a
specified value is a positive number, but will calculate a percentage
if the value is a negative number? I know how to write these formulas
separately, but cannot seem to get it right bringing them together in
|
| how to search a sheet using row and column headers | 09 May 2008 15:56 GMT | 2 |
There may be an easy solution to this query as it seems quite simple but i'm
tying my brain in knots trying to figure it out!
I have a table in a sheet which i want to populate with data from a table in
another sheet. the table i want to populate has a range of age groups down
|
| non match result | 09 May 2008 15:55 GMT | 1 |
I have two worksheets. Worksheet 1 represents a bulk listing of all unpaid
bills by customer number and its run at the beginning of the month.
Worksheet 2 represents the bulk listing of unpaid bills at midmonth. I want
to be able to compare the worksheets by customer number ...
|
|
| Charting (view all ...) | Last Post | Replies |
|
| Pivot charts filter field in 2007 | 09 May 2008 13:57 GMT | 2 |
I remember in Excel 2003 when you created a Pivot Charts you could drag and
drop the fields to the various areas such as Page area, Series and so on.
In 2007 I know that I can easily drag and drop the fields in the Pivot Tabel
filed list.
|
| Pie chart not appearing | 09 May 2008 13:45 GMT | - |
Has anybody got any suggestions as to why I can't see my pie chart when I've
selected the data, clicked pie chart. I can see the categories, but no chart
appears, however, if I select bar chart - as if by magic, hey presto, I have
a chart!!
|
| how to make cell turn red or green? Please help... | 09 May 2008 13:44 GMT | 1 |
In a row I have a one cell which is drop down list so I can choose a) or b)
value.
How can I make thet if I choose a) value, whole row turn green, or when I
choose b) value, whole row turn red?
|
| TROUBLESHOOT: SECONDARY AXIS v.07 | 09 May 2008 08:49 GMT | 1 |
sequence: highlight chart | format selection | series options | 'Plot Series
on' - that last bit does not appear in the menu (it just shows Gap
Depth/Width instructions).
I want to add a vertical secondary axis showing percentages, would this be
|
|
| Links (view all ...) | Last Post | Replies |
|
| Excel 2007 data link update prompt | 08 May 2008 11:58 GMT | 4 |
A user has recently upgraded from office 2003 to office 2007 on a Windows XP
SP2 machine.
This user used to receive a spreadsheet from a client via email to display
items ands costs, etc.
|
| Links to mapped drive change to refer to local hard drive | 08 May 2008 11:42 GMT | 1 |
We are running Excel 2000 under Windows XP. There are several spreadsheets
residing in a folder on a server to which 4 people have their O drive mapped.
These spreadsheets contain links to other files within these folders.
For 3 of the people, the links work perfectly but for one ...
|
| #VALUE! in cells when I open spreadsheet | 01 May 2008 00:41 GMT | 2 |
I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.
|
| Unwanted Change to File Name in Link | 28 Apr 2008 16:58 GMT | 2 |
I have posted this in excel.misc but this seems to be a better fit.
Apologies for the duplicate Post
I have an Excel workbook (Call it A) that extracts version informaton
from a series of templates.
|
|
| Printing (view all ...) | Last Post | Replies |
|
| Changing the "Print what" default | 07 May 2008 20:08 GMT | 3 |
Since upgrading to 2007, I wonder is there anyway to change the "print what"
default in Excel 2007. Currently the default is set to print the whole
workbook...I never print the workbook always the worksheet. I know you can
click the current worksheet button...but in 2003 I ...
|
| does excel have section break like in word? | 06 May 2008 09:46 GMT | - |
I have a worksheet which consists of only 2 columns and 10 pages long rows.
can't be better if excel provides section break like in word when printing.
any ideas?
I use excel 2007.
|
| Data Table moves when printed | 02 May 2008 20:38 GMT | - |
When using excel 2003 I had developed a very intricate chart that has a data
table at the bottom along the x-axis. Now when the XLS file is imported into
Excel 2007 it appears to be identical. However, whenever the chart is printed
the data table has been offset along the y axis ...
|
| Borders and Fill Not Printing | 02 May 2008 00:42 GMT | 2 |
Excel 2007. Yesterday the color fill in certain cells and the borders
throughout the spreadsheet were printing fine. Today they do not print, nor
do they appear in Print Preview. Thank you in advance for any assistance.
|
|
| Setup (view all ...) | Last Post | Replies |
|
| running multiple instances | 09 May 2008 15:08 GMT | 2 |
First of all this may not be as much as an excel issue as it could be a dual
monitor issue.
I have two monitors on one computer and would like to have two excel
spreadsheet open at once, one on one monitor and another on the other
|
| How to add info thru macro | 09 May 2008 03:57 GMT | - |
I need help with a macro that should help me add info to a sheet. I have a
list of customers, and I keep on adding, and I want to post the new customers
to the cutomer list by thru a macro, and it should add it to a new line to
the list and then sort the whole list to ...
|
| DEC2HEX with VBA in Excel 2007 | 08 May 2008 23:59 GMT | 5 |
I have a program working with Excel 2003 with VBA that uses the DEC2HEX
function within the VB routine (not in the Excel sheet)
I have turned the Analysis and the Analysis VBA add-in on.
I have also checked the atpvbaen.xls reference on in the VBA tools section.
|
| Variance Report - Need to reflect 0% | 08 May 2008 23:55 GMT | - |
Hello! I need my variance number to show 0% even when the formula's answer
is #DIV/0!
|
|
| Programming (view all ...) | Last Post | Replies |
|
| I am not sure | 09 May 2008 16:12 GMT | 2 |
Hello;
I am trying to help someone, for which I am not sure there exists a
solution. He has a .csv file that he is opening in Excel. The values,
somehow, import into the correct conglomeration of data. More in a minute.
|
| workbook / worksheet change event | 09 May 2008 16:12 GMT | 1 |
Is it possible to use the act of navigating to a different worksheet as an
event in VBA programming? For instance, if I had a workbook with multiple
worksheets, and the primary sheet that is displayed when the workbook is
opened is called "setup", I want to make sure that you ...
|
| Text Box - Initial Content | 09 May 2008 16:12 GMT | 5 |
I am using Excel 2000
I have a spread sheet with columns holding Date, Order No., Name, etc
I wish to generate a user form which will display data from a selected row,
i.e. the entry's date Order No., Name, etc in Text boxes.
|
| How best to break up code | 09 May 2008 16:09 GMT | 8 |
I hit the "procedure too large" error and I can't seem to get past it.
I'm well aware of the reason and I can tell you know that I've
effectively crammed all the IFs and LOOPs into it that I can, so let's
assume that the code can't be condensed further. I've spent half-a-day
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage