Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...Where is the lasso feature in 2008? (was in formatting palette in 2004)
Operating System: Mac OS X 10.5 (Leopard)
Hi, <br><br>In Excel 2004 in the formatting palette in image, there are different selection marquees and lasso's. Where are these features in 2008 Excel? I can't find them anywhere. <br><br>thnx
I just found my answer, the "genius's" at Microsoft / MAC Office decided to kill off all these editing features... <br><br>Over $200 to upgrade to a product with LESS features... I don't think so... unbelievable, I will continue to use 2004 because 2008...punblisher and word prcoessing software
can publisher be used as word processing sofware?
Not very successfully, it's a desktop publishing program. If you don't have
the $, download and install OpenOffice. OpenOffice Writer is an excellent
word processor — very similar to MS Word.
"shelagh" <email@example.com> wrote in message
> can publisher be used as word processing sofware?
It *could* but it's not the best tool for that job. Specifically what do you
want to do?
Microsoft MVP - Publisher
How to ask...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...Starting an Office Program (word, excel) in Outlook to send email
I'm taking an Outlook 2002 class. The latest assignment
requires I open a Microsoft app in Outlook to send an
email. Troubleshooting so far: Have tried to install some
addl features from CD, restarted the pc (O/S WINXP) but
still get error "Cannot complete action". Get no reason
why Outlook cannot perform this action and the HELP
hasn't only points me to inserting an object or some
variation thereof. My Outlook is configured to use with
Steps (abbreviated) given in textbook to perform:
New mail using Microsoft Office
Also tried to perform from Wo...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Excel 2007 PC damages Mac Excel 2008 Files
Operating System: Mac OS X 10.4 (Tiger)
When I open a Mac Excel 2008 file on Excel 2007 and I can work with the file, however when the file is returned to the Mac, it no longer works correctly, leading to a crash as soon as I try to save or eventually it might change the file to look like a bunch of letters and characters. Here is the error report: <br><br>Microsoft Error Reporting log version: 2.0 <br><br>Error Signature: <br>
Exception: EXC_BAD_ACCESS <br>
Date/Time: 2010-01-15 17:05:56 -0600 <br>
Application N...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...how can i edit the positioning of the balloon comment in a word fi
how can i edit the positioning of the balloon comment in a microsoft word
please reply on my email
What you can do is adjust the space reserved for the balloons in the margin.
In Word 2007, on the Review tab, click Track Changes, and then click Change
Tracking Options. Change the "Preferred width" setting.
Microsoft Word MVP
"melikelmalik" <firstname.lastname@example.org> wrote in message
> how can i edit the positioning of the balloon comment in a mi...SQL Server Connection Failed
Hi everybody, this is my scenario:
1. Windows Server 2008
2. WSS 3.0 + MOSS 2007
3. SQL Server 2008.
i'm having this problem: "Login failed for user 'sa'. Reason: An error
occurred while evaluating the password. [CLIENT: 22.214.171.124]".
in this momment i can't see any application from sharepoint. somebody knows
how can i do?
i don't change the sa password. i don't change anything in the sharepoint
configuration. since two days ago i'm having this problem. pls, is very
urgent, because i have to deliver this server the next monday to the...XY Scatter Map with Test Labels
Sorry if this is a repeated request, but I'm trying to show the distribution
of 16 points (labelled A through P) using X-Y coordinates. When I turn on
labels, I can show either the X-positions (label) or Y-positions (value), but
I really want to show the text name "A" through "P". Can this be automated
Thanks for any advice.
The easiest thing to do is use a free addin utility to allow you to link
data labels to cells.
Try Rob Bovey's XY Chart Labeler add-in
Mike K. wrote...Installed Font does not display in Word 2007
Only 6 of of 8 recently installed TTF fonts will display in Word 2007
Are the missing ones variants like Italic or Bold?
On Dec 25, 1:28=A0pm, GWHA <G...@discussions.microsoft.com> wrote:
> Only 6 of of 8 recently installed TTF fonts will display in Word 2007
...Word 2004 and kyocera printer issue
I am running a fully patched MAC OSX.4 machine with Office 2004 fully
I have installed the latest Kyocera OS X English 10.2 drivers from the
kyocera website, for KM7530 model.
The driver installs a job accounting feature in the printing presets
for that particular printer. The function will work fine for every
program other than word, word will not allow you the option to enter a
pin code. all the features seem to be greyed out.
If i reinstall and go immediately to anotherr program such as Eudora or
Firefox or even Excel I can enter and lock the pin number in and it
will print...searching a cell for a contained text word
Is it possible to search a cell for a key word or words contained in text
made of multiple words enabling the user to than create a pivot table using
the collected key word or words as data?
...Bank One Download is not working
We are trying to download transaction data directly from
Bank One and the file is not being recognized by Money -
i.e. the Bank One website states that the download is
complete, but Money does not recognize it. Note that a
file is being saved on our hard drive but we can't figure
out how to read it. It is entitled mnyimprt.exe-(numerous
numbers and letters follow).
In microsoft.public.money, Miki wrote:
>We are trying to download transaction data directly from
>Bank One and the file is not being recognized by Money -
>i.e. the Bank One website states that the downloa...Saving Pictures
I read all the info on the forum about saving pictures but when I open Power
Poing, I don't get the usual buttons at the top. It opens to a page layout
with Home, Insert, Page layout and so on. When I try to open the email just
to see what files are in it, it shows the slide show.
So, first save it to your hard drive.
Then open PowerPoint
Then Open the file within PPT
"skydiver9696" <email@example.com> a �crit dans le
message de news: 396594B0-40D7-4D7F-A560-6F93662A8D57@microsoft.com...
>I read all the info on the forum abou...Office 2008 "Office Installer" could not be opened
Trying to install Office 2008...
When I double click the Office Installer icon....I get the following message:
The document �Office Installer� could not be opened.
I'm on a MacBook Pro. I've never had problems installing programs before. This is new.
Thanks for any help.
On 2/26/08 2:03 PM, in article firstname.lastname@example.orgR9absDaxw,
"Dags@officeformac.com" <Dags@officeformac.com> wrote:
> Trying to install Office 2008...
> When I double click the Office Installer icon....I get the following message:
> The document �Office Installer� could ...Connect to my Skydrive Folders from Word 2007
I have installed the MS Office Live Add-in so that I can open and save
documents directly to my Office Live folders from within Word 2007. I would
like to do the same with my Skydrive but can't seem to connect to it from
within Word 2007.
Operating System: Mac OS X 10.6 (Snow Leopard)
How can I reduce the size of inserted pictures in the document WITHOUT linking them? Seems like I used to be able to do this on my pc in Word2003... My 35 page document with pictures is now 140MB!
The best approach is to process the images properly using a graphics app
*before* plunking them into any sort of document... If you drop in a 1.8MB
image it will increase the document's file size by that amount.
More recent version of Win Word do have a Compress Picture tool which Mac
Word does not have. ...Compact Now feature doesn;t seem to work...
I still have a 600+ MB in-box.
ANyone know hwta might keep it from compacting? I did
empty the trash.
Compacting only works when there is a certain percentage of white space in
the file (I think it's something like 4%)...if there isn't, Outlook doesn't
think there's anything to compact. Also, if you leave Outlook open long
enough, background compaction will be taking place.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
In news:5feb01c474ce$23bb29d0...How can I get the trial balloon to work?
I've downloaded the Works program trial balloon over and over, but when I try
to use the program it tells me to use a product key and the key I was given
(every time) doesn't work.
...Word find/replace equivalent of (word1|word2)
New poster, I did my best to search for this answer using keywords
such as: atomic grouping, alternatives, bar OR pip equivalent, etc...
but had no luck
My question is, is there/what is the Microsoft Word find/replace
equivalent of the regular expression
I've obviously tried | and \| with no luck. And any webpage I found
with discussion of advanced find/replace for word did not go into
Thanks so much!
Have you tried the article that is found here:
It might...how to change bullet size in MS Word 2007
how to change bullet size in MS Word 2007
"Noam" <Noam@discussions.microsoft.com> wrote in message
> how to change bullet size in MS Word 2007
Home toolbar on ribbon. Click the down pointing arrow on the bullet symbol
in Paragraph section. Click on Define new bullet. Click on Font. Click on
the point size for your new bullet size. Whatever you have typed with a
bullet will change to the new size or format you select.
Hope this helps, let us know.
I am trialling visio 2007 - I have imported a clip art picture (in this case
a celtic band) Does the programe allow me to modify the band so its becomes
curved - either convex or concave
You've got various options:
1) create the 'tranformed' image in an editor and then import into Visio
2) create a mask shape with a cut-out and place that over the top of your
imported image shape
3) create a fill pattern using your image and then apply the pattern to a
shape with your desired form
For the image editor route, there obviously the commercial products, bu...how to locate where an xslt stylesheet failed
After converting some .net code from using XslTransform to
XslCompiledTransform, one of my XSLs no longer runs. it fails with:
Attribute and namespace nodes cannot be added to the parent element after a
text, comment, pi, or sub-element node has already been added.
trouble is my stylesheet is long and complicated and I don't know where the
error was. is there any way of finding out which line number in the XSLT
produced the error? I tried it on Xml spy (which does tell you where the
error was) but the same transform doesn't fail in xml spy.
Andy Fish wrot...