Application works on one PC but not on another with same OS?
My application works OK on my PC (Windows 2000, latest server pack) but
not on my colleague's (same OS and SP).
One difference is that I have the .NET IDE installed on my machine, and
I used to have the same problem on my machine. An error was generated
because (IIRC) I was using an MFC string comparison method on a char
array. This worked in my debug config., but not in the release config.
I replaced the code with a strcmp method, and that fixed it on my
machine, but not on his.
Is there something I should update in his Window's installation when I
install the ap...Showing Specific Data from Master Sheet to Another Sheet
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
I have tried pivottables but I am having issues showing the data in it
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jo...junk email filter and links
I really did check old postings and couldn't find
answers! I run Win xp home, Outlook 2002. We had a
recent crash and everything was restored. Since then,
there is no option for turning on my junk email filter!
It will color them gray, but not move them. I've tried
all the updates to both windows and office that I could
find. Also since the restore, when I click on a link in
an email message, it can't find the right browser (?) or
something, so I can't link directly to the linked site,
but have to cut and paste to get there. Any help to be
Donna <anonym...Message Stuck in Outbox to Only One Particular Email Address
I have Outlook 2007 and have been using it for about 2 months or so. I have
encountered a problem with sending emails. I have sent emails to a
particular email address (WinTips-Tricks@yahoogroups.com ) and the emails
get stuck in the outbox. The CPU usage is very high (about 76%) and the
taskbar icon flashes furiously. If I look in the outbox, the email is also
doing a staccato flash. At the bottom of Outlook the send says complete,
yet the flashing taskbar icon, and flashing email in the outbox remain.
After awhile (about 2-3 minutes) this stops, but the email remains in the
outbox....How to substitute for a non-existing column in a joined table
Is there a simpler way than a UNION to return a default value of a joined
table for which a corresponding row does not exist?
The following example (not a working one, of course) illustrates what I'm
after. I'd like to return 'N/A' as c2name if there is no matching row in t2
WHEN NULL THEN 'N/A'
ELSE t2.name END) AS c2name,
LEFT JOIN t2 ON t2.t1pk = t1.pk
On 2010-04-21 21:05, bob wrote:
> Is there a simpler way than a UNION to return a default value of a joined
> table for which a ...update worksheet in one file with worksheet in another file
I want to have one worksheet in one of my excel files (file 1) to
reflect the contents of a worksheet in another file (file 2) every
time it is opened (file 1), that is, everytime it is opened this one
tab should reflect the last changes made on the tab in another file,
including formating. I suspect this is possible but I don't have a
clue how to do it. I have a few questions:
Can this be done without VBA? (I'm not even a beginner with VBA!)
I did search the web some and found the following that looks
http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadI...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...FORMATING COLUMNS..... HELP
I need to format columns to allow only 7 characters and the rest of the data
to go into column B
"JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message
>I need to format columns to allow only 7 characters and the rest of the
> to go into column B
If you mean that if a user types a lot of data into the one cell and that
when they reach 7 characters the rest of the data is automatically inserted
into the next cell, then I don't think you can do that....How to share info from one file to another?
I am wondering how I can share something perhaps from a cell of "file 1
to "file 2." I am familiar with how to do it from worksheet t
worksheet within a single file. From what I have heard I know that i
can be done but both files have to be located in the same folder.
Correct me if I am wrong and please tell me briefly how it can be done
I appologize if this is a newbie question. Thanks Chip Carlto
ChipCarlton's Profile: http://www.excelforum.com/member.php?action=getinfo&useri...Won't go to link
Firefox 2.0 & Outlook 2003
When I have a link in an email to a certain website it does not go there
when I click on it. I assume this is a setting in Firefox or Outlook.
Bob Newman <email@example.com> wrote:
> Firefox 2.0 & Outlook 2003
> When I have a link in an email to a certain website it does not go
> there when I click on it. I assume this is a setting in Firefox or
See if something here helps: http://www.slipstick.com/problems/firefox.htm
That is not it. I don't get any error messa...I'm looking for a community just like this one but for Entourge?
I need to lear how to import and what formats I can import into Microsoft
Entourge. I'm hoping that at least someone can tell me of a community just
like this one. Thank you.
> I need to lear how to import and what formats I can import into Microsoft
> Entourge. I'm hoping that at least someone can tell me of a community just
> like this one. Thank you.
Thank you very much Bob.
"Bob I" wrote:
> http://www.micros...Rows and Columns Settings Problem
How do you set rows and columns in a way that when you scrol
down/column you can always see a certain row(s)/column(s)
Message posted from http://www.ExcelForum.com
Check out XL Help for "Freeze Panes"
In article <JMorgan.firstname.lastname@example.org>,
JMorgan <<JMorgan.email@example.com>> wrote:
> How do you set rows and columns in a way that when you scroll
> down/column you can always see a certain row(s)/column(s).
Message posted from http://www.ExcelForum.com
...Question re:clustered column w/3D visual effect
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
This should be a hint to avoid the 3D effects. 3D charts are inflexible,
but more important, the 3D effects mask the information in the chart.
Peltier Technical Services, Inc....BULK Conditional Formatting
I've read the posts on conditional formatting for cell colour based o
another cell's value (eg. set the conditional formatting to "formul
is" and then "=A1>0" and set the colour as red / blue / whatever...)
however wondering if I can do this for an entire column withou
individually changing the conditional formatting for each cell one b
one (as there are over 400 rows).
Basically I need a formula that reads the contents of column B for th
particular row that is active.
Can anyone help
---------------------------------------------------------------...Charting depending on criteria & data series name as a column val
I want to chart some prices as I want to take a look at price trends.
My problems, and I can not figure out how to solve them, are:
1. Is it possible to dynamically change the chart depending on certain
criteria (product family & selected customers)
2. As the number of customers is variable and they are in one of the
columns. Is it possible to plot a series (customer name), depending on the
name of a column?
3. I want to chart the data based on the date, but just include the dates
available, to prevent periods of time showing no change (e.g. I don't want
monthly ticks for the x a...How to add another target to VidPN in WDDM driver?
Thanks all for the replies before and I'd like to ask few more
questions related to VidPN management of WDDM driver.
When WDDM miniport driver enumeratse child devices and connected
external monitors, it first detects its all child devices in
DxgkDdiQueryChildRelations, and next check each child actually has
connected output in DxgkDdiQueryChildStatus. So, to implement adding
another(virtual) monitor I faked one of given PDXGK_CHILD_STATUS
parameter(HotPlug.Connected) to have true. And I filled up followed
EDID query requests as well.
Then I could see another monitor attached ...Saving one page -- as Template?
Therre are several pages in a 40-page booklet I want to save to use in future
Is there a method to save these pages for re-us?
Or must I save the entire publication as a Template?
Can I copy single pages and paste in another .pub file?
Save the entire document and delete out the pages you don't want.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"cuig" <firstname.lastname@example.org> wrote in message
> Therre are several pages in...How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When
generating reports, I would like to filter per agency and display only the
rows associated with that agency.
Is there a tutorial or sample on how to do this?
It sounds like you are looking for Data / Filter / AutoFilter. Have a look
here for some basics:
"Jack" <email@example.com> wrote in message
> I have a spreadsheet that contains multiple agency id's in a column. When
> generati...enter-key works with two inputboxes but not with olny one.
There is a form with two inputboxes and a submit button.The focus is on the
When the user presses the enter-key without having entered some text, the
But if i remove the second inputbox, leaving only the first inputbox and the
submit button, pressing the enter-key without any text does not show the
can see the page is postbacked, but that's all.
Why does it work with two inputboxes and not with one? And how to fix...DNS Question
I am working with a customer that has 2 Small Biz servers in the same
office. These are on 2 domains, but the same subnet. I am having trouble
getting mail to route between the 2 domains. Each is Small Biz server 2003.
Domain A has a public IP of 188.8.131.52 and an internal IP of
192.168.200.78. Domain B has a public IP of 184.108.40.206 and an internal IP
of 192.168.200.250. We are using a Netgear firewall and inbound and outbound
mail between each of these domains and the rest of the world works fine. They
just can't seem to talk to each other. I would think this woul...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <firstname.lastname@example.org> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
...How do I remove cross hatches in Sigma column
Addition of a column results in cross hatches. How do I get rid of the cross
hatches and simply have the sum printed in the column?
Widen the cell so the resulting value will fit. Excel does this so you don't
accidentally SEE a number that's LESS than the actual number, which is what
would occur if the column wasn't wide enough.
wrote in message news:08545D7F-E1B3-4879-A7DB-A2B723DDCD3F@microsoft.com...
> Addition of a column results in cro...Column names
Is there any code to convert column(number) to column(letters), and V.V.
e.g. 27 for AA, AB for 28
"daniel chen" <email@example.com> wrote in message
> Is there any code to convert column(number) to column(letters), and V.V.
> e.g. 27 for AA, AB for 28
Great! Thanks. How about the other way?
i.e. 27 for AA
"Peo Sjoblom" <firstname.lastname@example.org> wrote in message
news:%23MpiXScTFHA.2560@TK2MSFTNG...comparing 2 similar columns on seperate work sheets in 1 workbook
How can I compare a column from worksheet 1 to a column in worksheet 2 of the
same work book?
BTW, the cell my have a number or text in it but not formulas
> How can I compare a column from worksheet 1 to a column in worksheet 2 of the
> same work book?
What are you looking for?
If you want to find out if each cell in Column A of sheet1 appears in column A
of sheet2, you could use a helper column of formulas:
and drag down
And you could use the same kind of formula that will tell you if values in
sheet2 appear in sheet1.
...Links won't work in emailed enewsletter, help!
Some links in my e-newletter are unactive when I email it. I've tried to
secure the text box with an exact position by going to the text box format
options and it won't even let me select this as an option. Any other
For hyperlinks to work the newsletter has to be HTML. Have you tried using a PDF
for your newsletter? You can make the hyperlinks active in a PDF file.
Do this search for a free converter. Not all of them have the feature you want.
Mary Sauer MSFT MVP