| General Excel Questions (view all ...) | Last Post | Replies |
|
| Guidelines for posting questions? | 04 Jul 2009 14:17 GMT | 4 |
I putting together a set of guideline for poster - which list the things we
most often need to answer a question. I already have a list but would like
any additional feedback from the rest of you.
For example, in the Mac forum every post starts with the OS, and version of
|
| Q about sheet protection | 04 Jul 2009 13:58 GMT | - |
I am using Excel 2007 and have a page that I have always used "Allow
Users to Edit Ranges" on. I have recently added two checkboxes (Form
Controls) to that page but I cannot figure out how to use the
checkboxes when I have the page protected.
|
| Still more on loading a .CSV into a .XSLS | 04 Jul 2009 13:20 GMT | 3 |
=========================================================
Dave,
Thank so much. It works perfectly. I just need to tell it what folder to
be looking in, to make the file selection. It will be a long path on a
|
| Macro Fill Cells With Formula; Conditional To Seperate Column | 04 Jul 2009 13:17 GMT | 3 |
I'm working on a spreadsheet where certain cells in columns need to be filled
with a formula, but only if cells in the same corresponding row from a
different column meet certain criteria. Example:
__|L__|M__|N__|O__|P__|Q__|R__|......|W__|
|
|
| New Users (view all ...) | Last Post | Replies |
|
| Making a MsgBox return cell data when search finds different data in an adjacent cell | 04 Jul 2009 13:37 GMT | 1 |
Thank you for helping me with this in advance. I'm grateful for all
the help I've found in these groups.
I'm running a macro that is searching a sheet for data. When it finds
that data, I need a msgbox to pop up with the data from that column's
|
| New Tab Debug | 04 Jul 2009 13:12 GMT | 1 |
Currently I am creating a new tab using a date formula (in a macro). I would
like it to check if the tab exists and if so, go to that sheet and do
whatever. It it does not exist create it and go to it and do whatever.
|
| a summary sheet | 04 Jul 2009 08:31 GMT | 1 |
Hello, I have a number of sheets in a workbook that have one stock item on
each which I update and then give me a reducing balance. Simply what I want
to do is have a separate sheet which has a summary of the each of the stock
items and automatically updates as I amend each ...
|
| how to output Excel file with field separators? | 04 Jul 2009 08:00 GMT | 2 |
I have an Excel spreadsheet, where some field columns may have 1 word
in it, some fields may have 2, 3 words in each field column, and so
forth. I would like to output this Excel spreadsheet to a text
document.
|
|
| Excel Errors (view all ...) | Last Post | Replies |
|
| Cannot access help in Excel 07, tried repair, says files missing. | 04 Jul 2009 01:34 GMT | - |
When I try to access help I get an error message that files are missing. When
I ran the repair, it said it was successful. When I tried help again, I got
the same message about missing files. Any suggestions?
|
| Excel run time error message | 04 Jul 2009 01:09 GMT | 3 |
Every time I open Excel I get an error message and would like to know how to
get rid of it. See message below.
Run-time error '-2147467259 (80004005)':
Method 'Add' of of object 'CommandBarControls' failed
|
| Excel glitch: I click on one cell and many more are selected | 03 Jul 2009 18:14 GMT | 1 |
I run Office Standard 2007 under Windows Vista and am experiencing a very
annoying problem: When I try to select only one cell or one row in my
spreadsheet and Excel selects multiple cells or multiple rows instead. Has
anyone found a solution to fixing this glitch???
|
| Can't UPDATE SOURCE in EDIT LINKS. Easy to duplicate bug. HELP! | 03 Jul 2009 00:21 GMT | 3 |
EXCEL 2007 SP2. I did a test with two linked workbooks just referencing
cells, the UPDATE SOURCE capability in EDIT LINKS works fine. However, if
you create a table ("FORMAT AS TABLE") and you reference that TABLE, then you
no longer have the ability to UPDATE SOURCE if you ...
|
|
| Worksheet Functions (view all ...) | Last Post | Replies |
|
| Sumifs, averageifs, countifs | 04 Jul 2009 13:46 GMT | 3 |
I am an excel trainer and I am trying to prep the new functions and I can't
get the ifs to work. If I use the functions for 1 criteria, it works, when I
add the 2nd, I get 0 for sumifs and countifs and #div/0! for averageifs.
=SUMIFS(E6:E23,D6:D23,"Sales") returns 166,000
|
| DSUM with criteria:blank OR > some value | 04 Jul 2009 13:28 GMT | 1 |
Cells in Column A, headed "date" are either blank or contain dates; cells in
column B, headed "Amount", contain a number.
I want to sum, using DSUM, cells in column B, where the corresponding cell
in column A is either blank or contains a date after a certain date. But
|
| Is there a maximun number of cells allowed in a name range? | 04 Jul 2009 13:24 GMT | 5 |
It appears to be the case, but I don't know what the maximun is, or if my
error is for another reason.
|
| SUM of areas | 04 Jul 2009 13:08 GMT | 7 |
Hi there, I have a list of invoices with postcodes, and I want to know the
amount per postcode. For example.
Column A Column B
Postcode Invoice amount
|
|
| Charting (view all ...) | Last Post | Replies |
|
| How do I create a Cumulative Frequency Histogram on Excel? | 04 Jul 2009 13:44 GMT | 1 |
I want to create a Cumulative Frequency Histogram on my Microsoft Excel 2007.
I can create a line graph or a column graph, but not both in the same graph.
There probably is a way to do this, but im not very familiar with graphs on
Excel 2007 yet, so any help is appreciated.
|
| Change Series Formulas for all charts on worksheet | 04 Jul 2009 04:31 GMT | 4 |
I have a workbook with a 'template' worksheet that has 4 charts that
reference data contained only in this worksheet .
When I copy the 'template' and rename it (say Project1), the 'Series
Values', 'Series Name', and 'Title' reference in the formula bar continue
|
| Pivot Table Resutls Don't Match the Graph | 04 Jul 2009 00:40 GMT | 1 |
I have three pivots and one pie graph all on one worksheet. Now, one of
pivots is supposed to generate the data into the pie graph and break it down
into percentages. However, for some reason the percentages from my pivot
don't match my graph. I tried looking at the decimal point ...
|
| empty columns not to be displayed | 03 Jul 2009 17:41 GMT | 1 |
I have a table that displays data depending upon values that a user selects
from a control box.
Based on these values, a column chart is displayed.
My problem is...depending upon the value that the user selects from the
|
|
| Links (view all ...) | Last Post | Replies |
|
| Can I sort cells containing links by the displayed value? | 30 Jun 2009 21:06 GMT | - |
My spreadsheet is created entirely from links to another spreadsheet. I
would like to sort this one by the displayed values, but keep the links
intact so I get the data updates. Is this possible without pasting the
values into new columns?
|
| Automatic updates of links betwe en files – Excel 2007 | 27 Jun 2009 05:52 GMT | 6 |
When I open a file with links to another file, a security warning shows in
the message bar showing that automatic update of links has been disabled.
When I go to the Trust Centre it shows that Prompt User on Automatic Update
of Links is selected.
|
| Problem with links form a word file to excel graphs | 23 Jun 2009 08:00 GMT | 3 |
I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007 the hyperlinks from the excel to the word
|
| Track Sales Weekly, Monthly and Annually with this Powerful Tool 16781 | 22 Jun 2009 03:42 GMT | - |
yUTbQ(jVF^V><twoUu=UMFxEz
|
|
| Printing (view all ...) | Last Post | Replies |
|
| Excel printing the top borders of the second page on page 1 | 25 Jun 2009 14:32 GMT | 1 |
Hi, I have list of data that requires borders and for some strange reason,
when I try to print page 1, it will carry the top cell borders of the next
page. I would just get rid of the row border but if I do, I still get a few
dots on the bottom of page that represents the borders ...
|
| Track Sales Weekly, Monthly and Annually with this Powerful Tool 75784 | 22 Jun 2009 03:42 GMT | - |
cR.,xbzKk!ju)a^Sq$DfodqoE
|
| Printing from other programs into Excel Spreadsheet format | 17 Jun 2009 19:48 GMT | - |
I am interested in printing output from a Windows based program into
Microsoft Excel.
I would like to evaluate this for an enterprise solution, as we need
to print from a SQL program into Excel constantly. We have QMF for
|
| Printing Problems | 12 Jun 2009 19:14 GMT | 1 |
I cannot print an entire worksheet that I have built. When I do a print
preview, everything looks fine but when I print it, only the first row prints
down the entire page. I've cleared and reset the print area but that doesn't
seem to affect the printing.
|
|
| Setup (view all ...) | Last Post | Replies |
|
| Setting up excel gradebook | 04 Jul 2009 00:20 GMT | 1 |
How can I get my final average column grades below 65 to appear in the color
red?
|
| Adding color to drop down box | 04 Jul 2009 00:19 GMT | 1 |
I have a spreadsheet where I keep track of the skill level of employees.
They can select from None, Beginner, Intermediate, Advanced and Expert. I
would like the text color to be different for each selection so that when I
look at the results if i am trying to find all those ...
|
| APPCRASH in Office Excel 2007 | 03 Jul 2009 13:46 GMT | - |
When I attempt to save a spreadsheet, I get a message that says, "Microsoft
Office Excel has stopped working." This does not happen every time, but with
increasing frequency. Here's the detail:
Problem signature:
|
| CSV File Opening Conversion Issue | 03 Jul 2009 11:42 GMT | 1 |
I have a user that when they try to open a CSV file from the desktop or any
other location the file does not open correctly. When the file is opened on
other machines using Excel it opens correctly.
What seems to be happening is in column A we are getting the first 14
|
|
| Programming (view all ...) | Last Post | Replies |
|
| Issue regarding Regional settings | 04 Jul 2009 14:04 GMT | - |
I am programming in VBA having set up the Greek Regional settings. This
means that in Greece we use “,” instead of “.” for decimals and “.” instead
of “,” for thousands. I had to pass an excel formula via VBA which is:
Dim num as Double
|
| Making a msgbox return a value in one cell, when data is searched and found in another. TIA | 04 Jul 2009 13:42 GMT | 2 |
Thank you for helping me with this in advance. I'm grateful for all
the help I've found in these groups.
I'm running a macro that is searching a sheet for data. When it finds
that data, I need a msgbox to pop up with the data from that column's
|
| Dropdown List Add New Feature Needed | 04 Jul 2009 11:41 GMT | 15 |
How can I create a button or list entry that takes the user to a cell to
add a "new item" or "new user" to a dropdown list array by way of row
insertion and cursor placement... that takes the last entry in the
existing drop down list to use as an "add new" "button" or trigger?
|
| RANGES AND DYNAMIC ARRAYS!! | 04 Jul 2009 11:25 GMT | 2 |
Hi - I have 2 questions:
1. I have dimmed and set a range like TestRange =("B:B,D:D,F:F,H:H").
How do I programmatically determine the last cell in the range that
contains data (as well as the address of this cell)?
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage