Excel 2007 Forgets Formatting
My employer upgraded our computers to Excel 2007 a couple of months ago.
Since that time, I have had several occasions in which Excel has "forgotten"
some of the formatting in a workbook.
This has happened when I have opened a workbook, done some work in it, and
then saved and closed the workbook. When I reopen the workbook later, some
of the cells are no longer formatted the way they were when I saved the
This has occurred both for files saved in "compatibility mode" (that is,
using the Excel 95-2003 file format) and in the new XTML format used by
Excel...Array formula: returning non-zero for negative search
I have an array formula: =SUM(IF(C2:C9="Apples",IF(I2:I9>=0,I2:I9,0),0)) where C2:C9 is product, H2:H9 is delivery date and I2:I9 is period since delivery. This works well where there are apples in C2:C9, but delivers zero when there are none, which causes problems in the subsequent formula. How do I get "24" as a result when there are no apples in C2:C9
I am a newbie, hope you can help
I think in row 2 for example Q2 write : "=if(exact
(C2;"apples");I2;0) and Enter .Then when your mouse is in
the right bottom of cell Q2 a + mark appears .drag it ...Lately, I've been reveiving a lot of dreaded SPAM with the following format in the Subject line
I have been recieving a huge amount of SPAM from the a-holes who do this
with the following pattern in the subject line:
Re: %RND_UC_CHAR[2-8], said hed come
Does anyone know what this is all about? Is this some new technique these
creeps have begun using to get around SPAM blockers? (It does get around
Did you check with Cloudmark support on this? Are you using the latest
> I have been recieving a huge amount of SPAM from the a-holes who do
> this with the following pattern in the subject line:
> Re: %RND_UC_CHAR[2-8], said ...Formulas don't calculate until SAVE (excel 2000)
I have a client who insists they have a spreadsheet in
which calculations of certain formulas do not occur until
they SAVE the spreadsheet. They say it used to always
auto-calculate upon entering in data into CELLS but
changed to NOW only calculating when they press the SAVE
I asked them if they started doing anything new or
different? They said they just recently started pasting
new columns from anything spreadsheet (provided by
It is an inconvenience to keep having to press SAVE.
It soulds as though Calculate has become manual....WriteProcessingInstruction formatting problem
I have a problem with the
XmlTextWriter.WriteProcessingInstruction method. This
method takes two parameters:
public override void WriteProcessingInstruction(
If text is either a null reference (Nothing in Visual
Basic) or String.Empty, this method writes a
ProcessingInstruction with no data content, for example <?
So i tried to write a processing instruction with the
parameter text set to null. What i got wasn't what i
expected: <?name ?>. This format is not well formed.
Is this a bug or do someone have an advice ...Some Excel formatting functions taking a long time to work
Excel 2000 SP3
When I first use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to wok. Meantime Excel is locked up until it completes that
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
I haven't used 2000 in a while but if my memory serves me your problem is
the programs normal behavior. I suspect microsoft code these areas as
separate items that need to be attached when they are first used in a
session. This no longer is t...Need a formula for multiple sums in a cloumn when rows vary
I am making a invoice I need a total for each truck, with a grand total at
the end. The number of rows for each truck in the amount column will vary. Is
it possible to have the text truck total to the left of the total? A small
example below, there will be more entries under each truck and more trucks
tr# date hrs rate amount
3 4/12/10 10 50 500
4/13/10 5 50 250
truck 3 total 750
4 4/10/10 1 50 50
truck 4 total 50
and so on
...Conditional format shapes
I'm looking to use data in a table (ie state names and population data) and
how to use data in the population column to change the color of polygon
shapes I create (ie shape of state traced on a background image of country
map.) Is it possible to use the conditional formatting option to change the
color of a polygon instead of only the cell? It would be great to use Excel
to do some GIS presentations. I've heard it can be done in VBA but I don't
know the code at all.
...Incrementing a formula by 20 automatically
I've searched, but the answers didn't seem to match what I was looking
I have two sheets.
On the sheet I'm pulling data into, I have the formula "=Results!B20"
sitting in cell "B14". This works fine, but I want to increment it to
"=Results!B40" in cell "B15" and so on. The Auto Fill handle doesn't
work for this and I have MANY cells I need to fill.
Any help is appreciated.
Microsoft MVP - Excel
<Bowbender@gmail.com> wrote in messag...Need a formula for a Marketing equipment log
I am trying to create an equipment log in excel that will automatically
update what equipment is in stock based on an entry log worksheet in the same
Currently I have a list of items and next to each item is a cell that holds
a formula for calculating any check outs of equipment that are entered on the
I do not want to have another page for returns, but instead to only have to
enter the date that the item has been returned on the same row as the
original check out.
I want this to then it turn, return the checked out item to the running
Any id...Modifying formula of calculated field depending ypon the selection of pagefield
In a pivot table depending upon the selection of a pagefield value I
have to populate the value of a calculated field in row.
Suppose Page field can have selections Income1 , Income2 and All then
my calculated field will use different formula for three selections.
I have tried some thing like this but its not working.
I will really appreciate a quick response.
Private Sub Worksheet_Calculate()
Private Sub CalculateIncomeSegment()
If Ac...Help with conditional formating #2
I'm running Excel 2003, Sp2.
I'm using conditional formatting to change the background color on some
Cellvalue = Color
A = red
B = green
C = blue
This works fine but due to changes in the workbook I now also need to be
able to format a fourth cellvalue, D = yellow. The built-in function
however only lets me set up conditional formatting for three values.
Is there any way to achieve this?
Use simple formatting to color the cell yellow. CF will take over for the first three values, and
it will be yellow for D. If you have ...Conditional Formatting #49
Is there a way of doing Conditional formatting, based on more than three
criteria? I want a cell colour to change to one of 10 colours depending on
the lookup value of another cell! (ie cell A2 will contain a name, and cells
A3 will then contain the team, which it has looked up)
...Access 2000 File Format in Access 2003
If I'm using Access 2003 to create Access 2000 format, is there any new
feature in Access 2003 which I can't apply in Access 2000 file ?
On Wed, 9 May 2007 14:20:23 +0700, "Vensia" <email@example.com> wrote:
>If I'm using Access 2003 to create Access 2000 format, is there any new
>feature in Access 2003 which I can't apply in Access 2000 file ?
there are many; however, are you deploying to users with Access 2000, or with Access 2003? The default format for your
database is (normally) 200...Can the data range in a chart contain a formula?
I want the data range in a chart to change depending on the value of a cell
in a worksheet. For example...
If A1=10, I want the data range to be B1:B10.
If A1=20, I want the data range to be B1:B20.
Does anyone know how I can achieve this?
Thanks in advance,
Thanks! It took me a while but I eventually got it working.
The OFFSET function is the key, it provides the mechanism to specify a
configurable range via a named formula. Getting the correct apostrophes in
the right places was a bit tricky as well.
"Paul Corrado" <firstname.lastname@example.org>...Format a single digit like "007"?
In the query result, I need to see (for example) a single digit number
(say that "7") as "007".
What is the function for this? I use FormatNumber function for other
Can you help me please?
try the following:
> In the query result, I need to see (for example) a single digit number
> (say that "7") as "007".
> What is the function for this? I use FormatNumber function for other
> Can you he...Multiply cells and format to currency in text format
I have 2 cells which I wish to multiply, and have the result be formatted in
text with the 2 decimal places.
3 x 1.55 = 4.65
2 x 4 = 8.00
This is going to be used with a program which requires it to be numbers
stored as text. Just basic cell formatting doesn't work.
Can some one please help?
On Tue, 22 Dec 2009 16:43:02 -0800, Paul Wilson
>I have 2 cells which I wish to multiply, and have the result be formatted in
>text with the 2 decimal places.
>3 x...Excel "Insert Comment" Formatting
Windows XP Home
How can I format the "Insert Comment" .....(open Workbook
> right click on a cell > left click > Insert
Comment)......in my Excel worksheet?
It opens now at Font Size 8. I would like it to open at a
larger Font Size and also have the Insert Comment window
saved at my chosen larger size (I know how to expand to a
larger size but want to save it at that size for next time
using Insert Comment in a different cell).
Start > settings > Control Panel > Display > Appearance Tab > Advanced.
Select...Formatting columns to show months, quarters, OR years
I deal with a lot of historical data. I usually use groups to be able to
view this data by months, quarters, and years. So if I only want to see
years I just click the highest level group. BUT...when I view the middle
group (quarters) it also shows me the highest group. I have tried different
ways of grouping but this is the best I can get.
Is there another cool way to view data like this? Maybe by naming columns
then have some sort of drop down box to choose what columns to view???
I am only an intermediate level, so please go easy...
maybe a pivot table is what yo...Problems with array formula
i have a spread sheet which has data about different sectors. I want to
find out the average of each sector.
This is teh formula i am using. If column e which has details about the
sector of each company matches the sector name in IU85 then give me the
average of correspondingdata in column j.
Now the issue is that some companies data is not present and they were
blank. It is giving error while computing the average. Secondly i tried
to change the blanks and added text in place of blanks. But it is still
giving me those errors.
Can anyone please...Sequential numbers in a formula?
I have a few formulas (OFFSET & MATCH) which are the same (with relative
references chanfing accordingly) and occupy cells B2:B500. In each
formula one of the function arguments refers to a single cell in the
adjacent column i.e A1:A500 which contains the numbers 1 to 500 (and the
column is hidden as the numbers are needed only in the formulas and not
to be displayed).
The numbers are used to give the relative row number in the ranges used
by OFFSET. So, the first formula uses 1 (via B2) and the second formula
uses 2 (via B3) and so on.
My question is: Can I somehow refer to a ...Unrecognized db format
I had this multi-user application installed on the common drive since May.
It's Access 2003, and two days ago started getting the "unrecognized db
format" mesage. I tried importing all into a blank db, got the same message
and no import. The issue was reported by multiple users.
Please let me know what you think.
How was your db setup. You mention multiple users... so your db was split so
the each user had their own front-end? What type of maintenance did you
implement?Do you have a backup?!
Have you compacted the db recently. Sadly, I...date format 03-23-08
I have a date column where the date are like this dd/mm/yyyy for exemple
I want that user chosses only the year and athe query returns the lines of
How to do ?
In design view of the query, in the Field row of a blank column of the
query design grid, enter a calculated field similar to this:
Then, in the Criteria of this column, enter whatever it is that relates
to your "user chooses". For example, if the user is entering the
required year in a textbox on a form, the Criteria would be like this:
[For...what is 'too many different cell formats' reply?
Read this KB article
On Thu, 16 Dec 2004 19:29:01 -0800, "tommy" <email@example.com>
Check these out:
I think Gord meant to include this article link:
XL: Error Message: Too Many Different Cell Formats
Gord Dibben wrote:
> Read this KB article
> On Thu, 16 Dec 2004 19:29:01 -0800, "tommy" <tommy@discussions...Time Format to Text Output
I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
23/09/2009 6:07:00 AM
22/09/2009 9:22:00 PM
22/09/2009 7:40:00 PM
I am in need of a formula that looks at these times, and based on their
values, displays a particular piece of text. (in this case "DAY", "AFT",
Any time between the following:
7:20:00 AM to 3:19:00 PM should display the word DAY
Any time between the following:
3:20:00 PM to 11:19:00PM should display the word AFT
Any time between the following: