Why doesn't my Clip art on Office online link work?
I can open my browser and get the clips this way, but I can not just click on
the link to go to my browser.
Click on what link?
MVP Microsoft [Publisher]
"cmaster" <firstname.lastname@example.org> wrote in message
>I can open my browser and get the clips this way, but I can not just click
> the link to go to my browser.
Once you open Publisher, and selct the type of publicatoin, if you go to
insert , picture,and then clip art, in the lower left corner of the window.
There...Excel Help Please quick question
i want to have a cell automatically fill its self in when another cell says a
eg - if i type "blue" into D5 i want D6 to automatically change to "yes"
Is this possible
In Cell D6 put this formula
On Nov 15, 7:13=A0pm, Tom Jacques <Tom
> i want to have a cell automatically fill its self in when another cell sa=
> certain thing.
> eg - if i type "blue" into D5 i want D6 to automatically change t...How to open embedded documents in excel cells?
Operating System: Mac OS X 10.6 (Snow Leopard)
I have an Excel spreadsheet created on a windows machine that contains embedded documents. <br>
When I double-click in the cell I get the following message: 'Cannot start the source application for this object'. <br>
The formula bar for this cell reads =EMBED("Wordpad.Document.1",""). <br>
How can I open the embedded document with TextEdit.app or any other application on my mac? Is there a way to configure this? <br>
Any feedback is apprecia...Oulook 2002 Opens up on its own
I have a PC with windows 2000 and Office XP on it that is
showing some strange behavior. What happens is that every
thirty minutes or so, Outlook will just open itself and
appear in front of all open screens. It is really quite
I have 10 identical machines, all with fresh loads of
win2k and Office XP but this is the only one that is doing
Has anyone else seen this before?
...Editing Text when using Publisher as a web page...
I'm using Publisher to document the status of current taskings in the office.
I'm trying to ger Publisher to allow people that pull up the web-page to add
and edit text on the web page so we can keep everything up to date. Right
now, someone has to come to me and tell me the changes, then I change the
info in the Pub doc, then I have to repost the web-page. Is there a way for
people to edit the text on the web-page when they pull it up. I have text
boxes in there now that people can edit, but the text doesn't update when you
close the page and re-open it. Please Help if you ...How do I stop lines of text breaking where I don't want them to?
>> Mr Devlin asked Sen-Sgt Hurley if he was aware that (police procedural)
>> clearly prohibit officers (involved in any incident to be investigated)
>> from talking
>> among themselves because it may contaminate evidence.
How do I make the lines wrap correctly?
If you click on the Show/Hide (¶) button and it reveals a ¶ after the words
"rules" and "talking", See the article "Cleaning up text pasted from the
Hope this helps.
...SQL Server 2000 Standard Edition vs SQL 2000 Personnel Edition
I am using SQL server 2000 standard Edition sp3 with Gp 9 Sp3, I am planning
to move GP with database to new server different hardware.
can I use sql 2000 personnel edition sp3 or should I use same old version.
I hope u understand my question.
Generally speaking, personal editions are not robust enough to support a
product like GP. I would stay away.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"MK KSA&quo...Excel 2003 restarts after closing
Excel 2003 restarts after closing the program. Word and Outlook also. What
is causing this? I have an HP notebook with Vista and Office 2003
...How can i change the default line weight in an excel chart
I select a heavier line weight for a Pivotchart graph so it is easier to see,
however every time i change something on the graph from the drop down box the
line weight goes back to it default (lighter) weight.
...Copying Between Databases Without Linked Servers?
I have a SQL Server 2005 machine called "Dest" and a 2008 machine
called "Source" and a 2008 machine called "Console". Each has the same
SQL account with appropriate permissions and rights on all 3 to do
Without using a linked server, how can I sit at "Console" and execute
a "select into" fromthe "Source" database to the "Dest" database?
"SnapDive" <SnapDive@community.nospam> wrote in message
>I have a SQL Server 200...Excel Worksheet manipulation
How do you keep related data on multiple worksheets in order when you sort
the top worksheet
I don't use formulas like:
in those other sheets.
I try to find a unique key field (column) and populate those other worksheets
with the same keys (just copy|paste--not formulas).
Then I use =vlookup() or =index(match()) to return the values corresponding to
those unique keys.
You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
http://www.contextures.com/xlFunctions03.html (for =index(match()))
&g...editting auto recovery
is it possible to change the auto recovery directory just for one document
and is also possible to ensure that the auto recovery file is not deleted
after the file is closed?
AFAIK this is not possible. But you may consider using the following
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> is it possible to change the auto recovery directory just for one
> document and is also possible to ensure that the auto recovery file
> ...Won't Allow Clicking a Link in a Message
Suddenly, Outlook will no longer allow me to click on a link or picture that takes me to a website. I get an error message that says:
This operation has been canceled due to restrictions in effect on this computer. Please contact your System Administrator.
I compared my Security settings with my wife's settings and everything checks out the same as hers.
Any ideas on this issue? Your help is greatly appreciated.
Submitted using http://www.outlookforums.com
"Jim" <jim[at]walkersdomain[dot]com> wrote in message
Is there a macro that can be used to round, say to 2 decimal places,
number of highlighted cells, say a column
Message posted from http://www.ExcelForum.com
you may try the following code:
dim rng as range
dim c as range
set rng = selection
for each c in selection
if IsNumeric (c.value) then
c.value = Round(c.value,2)
Highlight your column and invoke this macro
> Is there a macro that can be used to round, say to 2 decimal places,
> number of highlighted cells, say a column?
>...template edit question, add more? edit template?
Operating System: Mac OS X 10.6 (Snow Leopard)
i'm using a resume template and it's beautiful, but only allows four job positions before it moves one the education, etc. <br><br><i>guess theres a way to do it on the pc version, but with mac, how do i insert an addition formatted block? it will only let me work within the template currently.</i> <br><br><i>hope that makes sense, thanks for the help!</i>
Mac or PC makes no difference � it's a matter of how the template is
constructed. With...BOM & Edit List
I created an Assembly transaction and printed it from the Assembly
transaction entry window before posting it.
In the posting journal that prints it does not print the Assemble cost,
extended assemble cost, Unit cost of the components and the extended cost.
But if i post the transaction then the same posting journal is printed with
Why does it not print?
Please let me know
It only pulls posted costs, like other Great Plains edit lists including
items. You will need to modify the report to include costs.
> I created...Adding a control line to excel chart without showing up in the leg
How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?
Any sugestions would be greatly appreciated.
On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver <TWeaver@discussions.microsoft.com> said:
>How can I add a control line, (such as average, ucl, lcl), to an excel bar or
>line chart and not have the control line series show up in the chart legend,
>or data table?
Single-click twice on the legend entry for the control line, and ...Link To A Cell From Chart
I have a text box in a chart worksheet. Can I link it to an information from
any cell in other worksheet in the same workbook.
Yes. Click the text box icon, then click on the chart sheet to insert the
text box. Click in the formula bar and =Sheet1!A2 (or whatever cell you want
Greeting from the Gulf Coast!
"Salza" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Hi all.
> I have a text box in a chart worksheet. Can I link it to an information
> any cell in other worksheet in...How to edit entitys attributes directly?
I messed up with entity mappings and ended up with errror: attribute not found.
How can I manually remove attribute from entity?
Tried export -edit -import but it seems not to be the right way.
You will first need to remove the "bad" mapping that you created. Since it
is referncing the field, you need to do that prior to trying to remove the
field. You also need to remove it from any forms & views that may be
The customization Import will not remove fields (as you have discovered).
That is done as a safety feature to rpevent accidental loss of data (ima...CThreadLocalObject Crash on Exit
I recently ported an app from VC2003 to VC2005. My app now crashes on
exit. The following is the stack trace from the app.
mfc80d.dll!CThreadLocalObject::GetData(CNoTrackObject * (void)*
pfnCreateObject=0x78245650) Line 409 + 0x3 bytes C++
mfc80d.dll!CThreadLocal<AFX_MODULE_THREAD_STATE>::GetData() Line 177
+ 0xd bytes C++
mfc80d.dll!AfxGetModuleThreadState() Line 464 + 0x11 bytes C++
mfc80d.dll!AfxWinTerm() Line 47 + 0x5 bytes C++
mfc80d.dll!AfxWinMain(HINSTANCE__ * hInstance=0x00400000, HINSTANCE__
* hPrevInstance=0x00000000, char * lpCmdLine=0x0015233a, int
nCmdShow=1) Lin...Training in Excel
Has anyone received their training from a Global Knowledge, Inc. Excel
training course. If not, do you have an e-mail address for a contact at
Global Knowledge that has been responsive to you. I have a question about a
Global Knowledge, Inc. Excel exercise and will require the files supplied
with the course for the answer. A cell is not responding as it should and I
want to know if it is due to a default or an error in formatting the cell or
precedent. Any help anyone could provide would be of value to me. Product
version is 2003. Thanks in advance.
I don't know any...Excel 97 tabs
Is there a way to change the fonts and/or background
colors on the Excel 97 file tabs?
This was established in Excel XP
"SS" <email@example.com> wrote in message
: Is there a way to change the fonts and/or background
: colors on the Excel 97 file tabs?
It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)
Web addresses are also welcome.
You can also post to my e-mail above.
Thank you in advance.
I would advise you go to the newsgroup "microsoft.public.excel.links", and
read everything you can about their troubles there and the
Vaya con Dios,
"Mustafa" <firstname.lastname@example.org> wrote in messag...