How do I remove empty chart plots from linked worksheet charts
Using Excel 2003, I have a workbook with a master worksheet and an associated
line chart, also several derivative worksheets with associated individual
line charts. The other worksheets are all linked to their respective columns
on the master sheet so that as the master is periodically updated, the others
The problem is that currently empty cells on the master sheet are displayed
as zero's on the linked worksheets and subsequently plotted on their
individual respective charts. The zero's can be removed from both the linked
worksheets and their respective ...IIf works in query but not in report
Does the IIf function work differently in queries from the way it works in
For example, this works in a query:
(I can hid the last name "Smith" in the lastName field.)
However, I cannot use the same IIf as a control source in a report. It
generates a circular reference error message.
(If the name is not "Smith", then print it.)
Is this just how IIf works?
I have a problem with a server install in which the IIS configuration is
corrupt. Outlook clients can still connect but the Internet explorer client
don’t work anymore.
Is it possible to uninstall the CRM server and install it again. I will
leave the database intact. Are the Outlook clients affected?
Server is windows 2000 - IIS 5
yes you can uninstall the crm web server and reinstall then point to an
existing database ie the sql database.
Make sure your outlook clients go into online mode in case they have any
data that needs synching
however you may want to try and troubleshoot thi...OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unspecified error".
I want to update with same tables an online sql server with local data of a
The online and local tables structures are the same, the name of the table
I receive this error:
OLE DB provider "SQLNCLI" for linked server "(null)" returned message
the code is:
connNostrosql1 = "Provider=SQLOLEDB;Data
INSERT INTO MAGAnagrafica...work in 2003 mode if I have 2007?
Is it possible to work in 2003 mode if I have PPT 2007? I don't mean working
in a 2003 document and saving it down to 2003.
I need to create an organization chart in PPT 2007, but my custmer only has
2003, and they need to edit it. when I save it down to 2003, it is not
Saving it as a 2003 file shouldn't make it un-editable, but why not just
have your customer load the file converter, so they can open the 2007 doc.
They would not have all the new effects or features of 2007, so you would
need to design it accordingly.
http...Compact & Repair, It Works and then It Doesn't... Help?!?
I have run into a problem with the "compact and repair" feature on my Access
2003. Recently I had my PC upgraded and had my IT PC Technician reload
Office Professional and all upgrades, so it is current in that department.
My PC is part of a distributed network and I access and administer databases
across that same distributed network.
The problem is that when I try to compact and repair (C&R) my databases I
have some mixed results.
1) On my local drives, it works fine.
2) On the network drives/shares I have a problem that the compact and
repair works on some dri...Windows Media Player (WMP) ripping errors/problems/doesn't work
To put it simply, my WMP's ripping is malfunctioning. The details are as the
At some point, when I tried to rip a CD into my hard drive using WMP, it
didn't work properly. The ripping process all looked fine, and WMP didn't pop
up any error signs or such; the ripping process looked completely normal and
was completed. The problem started when I tried to play the ripped music. The
audio files were present in the folder I was looking for, and I tried to play
them. But WMP won't play them, saying this:
"Windows Media Player cannot play the file. Th...customise outlook today not working
when I press on the customise outlook today button nothing
happens, the customisation screen does not load. I have
run a detect and repair, reinstalled outlook 2000 over the
top and also recreated my outlook profile. Someone else
logged into the pc and it doesnt work for them either (but
they can do it on their pc) so I'm thinking its a registry
hack somewhere, any ideas?
The following MSKB article provides the fix for this issue.
OL2000: You Cannot Customize Outlook Today After You Install Critical
Update 813489 for Internet Explorer:
http://support.microsoft.com/default.aspx?s...linking to documents
I am creating a webapge in publisher. I have buttons on a navigation bar. I
can link those buttons to existing webpages or "places within this document".
However, if I try to link one to a file, say a word.doc file it appears the
link was successful. When I do a webpage preview, however, and click the
button, it doesn't seem to activate????
On Wed, 3 Aug 2005 16:11:21 +0100, scrabtree23 wrote
(in article <110F6DC0-F3BD-4414-A4C2-077D9E4081C6@microsoft.com>):
> I am creating a webapge in publisher. I have buttons on a navigation bar. I
> can link those ...Open link in Excel, not Windows explorer
We have an Intrnet search which locates specific excel files on our
network. When you click on the link to the workbook, it open the
workbok in Windows Explorer, not actually launching Excel. This is a
problem because among other things, print preview is not available.
How can we alter this so that when you click on the hyper link, it will
amthyst826's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28308
View this thread: http://www.excelforum.com/s...How do I change how links in E-mails are opened? Outlook 2007
I'm using Outlook 2007 and whenever I click a link in an e-mail that goes to
a website it tries to open it in the Outlook window instead of using my
internet browser. This REALLY bugs me. Is there any way the change this so
that the link will open in a new IE or Firefox window? Microsoft Help has
been useless and I can't seem to find a solution online anywhere.
What is the program associated with web pages under Folder Options->File
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook versi...pdf links #2
how do i create a link that when you click on it, it will open the pdf
document in a new window?
...Outlook 2002 Won't Snd/Rcv but Test Settings Works
Just recently, when I press the send/receive button, it
fails to do so. It's a hit or miss occurance, happening
for a while every day for the last week. When I check my
account settings, they're all exactly as they should be
(other computers on the same network use the same
settings and have no issues). When I hit the 'Test
Account Settings' button, it works perfectly. Yet when I
go to check for the test mail, the send/receive no longer
works (I checked my mail using webmail and the test
emails were there). Basically I've been able to find no
correlation with...2005: Update Retirement Account working OK for others?
Every month I use the somewhat tedious Update Retirement Account wizard to
enter the month's 401(k) transactions. Since upgrading to Money 2005, I get
an error at the end of the process when I click the Finish button: "Your
information is being saved. If the problem persists..." When I click OK,
none of my data is saved.
Anyone else having the same problem? I've tried everything...work offline,
delete the online data, recreate the online data, etc. Thanks!
Yes, I'm experiencing the same problem with Money 2005 Premium on Windows XP
with Service Pack 2.
I...formula adding cells in worksheets when # of sheets in work book changes
I have a workbook template which contains a worksheet for each day o
the month and a summary sheet which totals cells from the dail
worksheets. The problem is that each month does not have the sam
number of days, so the cells of the summary sheet needs to have th
range changed when there is a different number of days.
Is there a way to write a formula to include only worksheets that ar
present - ie when a new file is created from the template i
automatically has worksheets for 31 days - and a worksheet will b
deleted if there are only 30 days. Is there a way to create a formul
so that the f...work flow wait condition is not working for datetime field added to entity in MS CRM
Microsoft CRM : Does the work flow wait condition work for a
customised(added) datetime field?
This is not working for datetime field added to case entity? any help
will be appreciated
...97 to 2003 conversion
I have converted a 97 mdb to 2003 that uses access
security. Everthing I've read states that the mdw file
can still be used in 2003. When I join the MDW and open
the database I get a Runtime Error '3112' no permission
to MsysAccounts. I can open the security/user and group
accounts and no users are listed. If I try to add one of
the uses it says the user already exists.
> no permission MsysAccounts
Bad news I'm afraid. It's an unfixed bug resulting from a system.mdw
ORIGINALLY being converted from an Access2.0 system.mda. The bug manifests
from Ac...Concatenate spaces before each alt-enter seperated value in a cell?
I hope I am making sense.
Within one cell, I have several values seperated by alt-enter. So it
I want spaces before each "abcdef" so it will look like this:
This gets close:
=REPT(" ",4)&SUBSTITUTE(A1,CHAR(10),CHAR(10)&REPT(" ",4))
But it actually adds extra characters at the right end of the string.
Change the 4 (in both spots) to how many space characters you want.
wa...Clipboard / Drag&Drop not working
Over the last few weeks both the Office Clipboard and the drag and drop
feature have stopped working. The clipboard shows an error message along the
lines of "Not collected - format not supported" but I'm only trying to copy a
few words from one part of a Word document to another part.
A very clumsy workaround is to have two copies of the document open, one in
Word and one in Wordpad, and then copy from Wordpad into Word - but it's very
Have run Norton virus scan, Spysweeper, used Regedit to delete the Data key.
Nothing seems to work. Any fresh i...refresh linked query
i have a pivot table in an excel sheet that is linked to an access database.
i would like to program a macro to refresh the pivot table. i thought the
following would work, but it does not:
FinalRowFRONT = Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("a" & FinalRowFRONT).Select
how do i get the pivot table to refresh?
The macro recorder is you friend :)
"joemeshuggah" <email@example.com> wrote in messa...Recipient Update policy not working correctly
I am having an issue with creating new users/mailboxes. I can create users
normally on a Windows 2003 server w/ Exchange 2003 SP1. However, the user
mailboxes and email address are not being generated properly. If we wait
they are usually created within a 24 hr period, or if the server is
restarted they are created. I have check the update policies and everything
appears to be configured correctly. The 2003 server was added to an
existing Windows 2000 AD, if that helps at all. Is there anyway to correct
this, or a way to manually add the mail settings?
maybe this KB may he...Synchronized Combo Box Not Working
I have been working on this issue for hours and have spent many days trying
to read the board to solve my issue, but I cannot, which is why I am posting
I cannot get my drop down boxes to work.
I am simply trying to use two drop down boxes and limit the second drop down
box based on a selection I made in the first drop down box. Here is what I
have so far:
Form Name: fBenchmarkJobDetails
Fields in tBenchmarkJobDetails
And so on…
First Drop Down Box
Control So...Last Working Day In Month
What is the formula for the last working day in month?
Winston's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28344
View this thread: http://www.excelforum.com/showthread.php?threadid=480968
Please define working day... is that a Friday or a Saturday?
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
...Enabling Radio button at runtime not working
I have a class derived from CPropertyPage. At design time I am setting
RADIO button to DISABLED state. At run time I want to enable this radio
Both of the fallowing failed.
Pls let me know how to do.
<firstname.lastname@example.org> wrote in message
> I have a class derived from CPropertyPage. At design time I am setting
> RADIO button to DISABLED state. At run time I want...Also the Edit in Excel button has stopped working
When a user opens a spreadsheet from Companyweb it opens ReadOnly and there
is a button which says Edit at the top. Clicking this button has no effect.
This worked fine until a few days ago
will this help ?
"gocat2005" <email@example.com> wrote in message
> When a user opens a spreadsheet from Companyweb it opens ReadOnly and
> is a button which says ...