Inserting excel doc into ppt
Is there a way to insert a sheet or info from a sheet from excel into
powerpoint? I have a program outline I want to insert into my presentation.
Here is one way to do it:-
1. I have a Title Only slide on the screen in front of me.
2. Insert / Text group / Object / Insert Object pop up window launches /
click on the Create from file radio button / Browse / in the File name: field
type in the full path of where your file is and its name / Open / OK.
3. The sheet from the targeted Workbook will now be pulled into your
Re-size as desired.
4. ...Excel 2003 dissapearing buttons
I upgraded recently from Office XP to Office 2003.
One of my workbooks stored on my local drive contained six command buttons
on the worksheet which each called a macro stored in the workbook not in the
After upgrade, when I open the file, I see all of the buttons for a fraction
of a second then they dissapear.
The macros are still in the workbook, the on_click code for the buttons
which call the macros is also still there but the buttons disappear.
By clicking around the area where the buttons should be one of them suddenly
becomes visible, does its thing and disapears again.
...Missing Measures in .cub file created in Excel
After using Excel's Offline OLAP features which create a
local cube file (.cub), many of the desired measures
which I included in the wizard setup are not displayed.
I'm looking for a reason for this.
The data populating this cube file is from a virtual
cube, so background calculations take place. I
considered that those measures requiring calculation
would not be included once seperated from the original
virtual cube... but many calculated measures WERE
included so I don't think that's the complete explination.
I've varied the measures included in the .cub file...pivot chart, mean and standard error
I'm using a pivot table to calculate the mean and the stdevp of values
collected in different condition.
My problem is to draw the corresponding chart for the means of the
values, and using the stdevp values for the error bars.
Using a stacked histogram, I have something which resembles to what I
would like but I would prefer to have a classical error bar. Is there a
way to manage ? I want to keep something automatic and not static, with
a copy/paste values to draw manually my charts.
Thanks for your help
Misange migrateuse http://www.excelabo.net
mail : http://cerbermail.c...How do I enter a decimal in a string of numbers in Excel? Example.
Please post your question in the BODY of the message, not the subject line,
and clarify with an example of the initial data and what you want to end up
with. If it's to translate 123 to 1.23, you divide by 100.
On Wed, 9 Feb 2005 15:03:07 -0800, Joy <Joy@discussions.microsoft.com> wrote:
...Stacked Line Chart
I have a chart that is predominately a stacked bar chart however I want to
have 3 sections as a stacked line chart as the represent hours for the whole
group. I can sucessfully set it for 2 stacked lines but when I add the 3rd
line if it has either a blank or 0 in the cell it picks up the line from the
previous stacked line. Is it possible to have 3 stacked lines?
Sure it's possible, but I don't know what you mean, "it picks up the line
from the previous stacked line". Stacked means each line's value is added to
the previous total, so if the value of the third it...Report from Access 2003 to 2007 problem
I have converted a database designed in 2003 to 2007. One of the reports
unfortunately does not work the same as it did in 2003. The report
generates invoices and on the form I had put in a text box with the Control
Source property set to [Enter Invoice Date] which brings up a dialog box
when the report is run asking the user to put in a date. This works ok in
2003 but comes up as #Error in 2007 in the report generated.
In 2007 report design, the text box has a green triangle on it indicating an
error "Invalid Control Property: Control Source" & "No such field in t...New Chart in Excel 2007 is NOT showed unless preview
I have a sheet with multiple charts in Excel 2007
one of the new created charts is hidden when I open the file
Unless preview is selected, then finally turned on BUT many formats are
changed and objects on charts (titles,...) can not be moved !
what's wrong ?
Make sure you have installed SP2 for Office 2007 as this fixes some (not
all) chart problems
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:0B0A3E5C-AABD-4982-962B-8C5C09A2CC5A@microsoft...How to draw a regression line on 7000+ dated data with Excel 2007
How to draw a regression line on 7000+ dated data using Excel 2007
Are your "dates" actual Excel dates or just text?
With actual Excel dates, pre-2007 versions have no problem doing simple
linear regression. To interpret the results though, you need to remember how
Excel dates are stored: An Excel date is the number of days since 1900, so
the numeric value of today's date is 39736, and the intercept of the
regression will be the value of the relationship extrapolated to 30Dec1899
(since Excel mistakenly considers 1900 to be a leap year)
"Gordon Lee" wrote:
>...How do I create an area and line combination chart?
I want tocreate a combination chart, using the chart types area and line, it
is not listed as a custom type in Excel - is it possible?
Ignore the built-in combinations and create your own.
Start with creating a Line chart with your data. Then select the line
series that you want as an area chart. Right click and pick Chart Type
to select the required Area chart type.
> I want tocreate a combination chart, using the chart types area and line, it
> is not listed as a custom type in Excel - is it possible?
Andy Pope, Microsoft MVP - Excel
http://ww...Export Report To Excel
XP, Office 2007
I have a report that when run basically tells us the part number, how many
are in stock, and how many we need to make to complete a particular order.
There are several order dates to each part, so the rows repeat themselves for
each of the order dates. There are total fields on the report that show how
many parts need to be made if the customer orders more than what is on hand;
all the calculations are done in the report itself. I was able to use a
macro to filter everythihg down to show for each part number the first due
date for parts that need to be manufactured an...Turning off all Automatic Formatting in Excel 2003
Is there any way of turning off all automatic formatting in Excel 2003?
For example Excel automatically changes strings such as 1-12 in a CSV file
to 1-Dec, 10-10-2005 to 10/10/2005 and strings of numbers to an exponential
representation. These changes are preserved when saving the file and thus
corrupting it, preventing any other applications from reading it.
I know you can import CSVs changing all the fields to text using the data
import option, however reopening it and saving causes Excel to make the same
Any suggestions would be really appreciated as this is caus...Excel asking for save with no changes #5
Dave Peterson Wrote:
> And xl2002 added an option that allows you to have more control:
> Edit|links|startup prompt button.
> check the "don't display the alert and update links"
This sounds like exactly what I'm looking for! Unfortunately, I'
running an older version of Excel. I'll have to hit up my IT perso
for an update. Thanks!
tommy20's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281
View this thread: http://www.excelforum.com/sh...Deleting rows in Excel based on criteria
Is it possible to automate the deletion of row based on a
criteria, preferably through a macro? i.e. - run the
macro and delete any row who has "NO" in last column.
>and delete any row who has "NO" in last column.
last column IV ??
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"SteveM" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Is it possible to automate the deletion of row based on a
> criteria, preferably through a macro? i.e. - run the
> macro an...Programmatically sign Excel VBA macro
My goal is to programmatically sign an Excel VBA macro.
I have a certificate.
I have code to programmatically create an Excel macro.
Word 2002 has access to the Office SignatureSet collection
(ActiveDocument.Signatures which prompts the user to select a certificate via
the Add method of the SignatureSet collection, which is an interface--not a
class--in the Office Interop PIA). Excel does not have a get_Signatures. Why
not?! Who cares, I don't want to prompt the user to identify a certificate
from the store anyway.
Now, I'm thinking, if I had something like SignCode.exe fro...How do I prevent Excel from replacing path in hyperlink when saved
I´ve created a hyperlink in a cell using the Insert Hyperlink option. I'm
using the path (F:\myfile.txt). When I save the document, the hyperlink
changes to (\\MyServer\MyPath\myfile.txt). Is it possible to prevent this,
because if the servername is changed in the future the link won't work
Use the =HYPERLINK() function:
Gary''s Student - gsnu200810
"Rico B. Raben" wrote:
> I´ve created a hyperlink in a cell using the Insert Hyperlink option. I'm
> using the path (...convert from excel to adobe
I tried to convert from Excel to adobe and it ended up
with black background and no words.
I tested to convert from MS Word and webpage to adobe -
I suspected that it had to do with the Excel setting for
Where can I fix the setting in Excel to make it normal to
convert it into adobe?
I saw "change conversion setting" under Adobe on the menu
in Excel application but i don't know which one is the
problem in the setting.
...Stock High-Low-Close Chart
Is it possible to produce a Hi-Lo-Close chart with reversed axes - ie with
the Hi-Lo bars horizontal rather than vertical? The normal HLC chart has
stocks listed along the x axis and price up the y axis. How would I switch
I want to display a series of stocks listed down the y axis and the hilo
price range given across the x-axis.
Thanks for any advice on this.
Assuming your data is first set up like this and cover the range A1:D8:
High Close Low
Conoco 41 39.5 38
Exxon 42 40.5 39
Shell 41 39.5 38
Baker 40 38.5 37
Halliburton 39 37.5 36
Marathon 40 38.5 37
Diamond 40...Problem opening Excel 2003 in a Small Business edition
When i open excel ,it appears a window "installing:function of Excel"
Its seems like installing a new function of Excel , it last a few seconds
we can work wiht it.
How can i eliminate this
You could try looking into your tools>Add-ins to determine what function
packs are being loaded when you start Excel. If this is poiting to an add-in
on a network drive, it could be what is causing the delay. You can try this
by unchecking each option in turn and closing and re-opening Excel.
Hope this helps
""installing:function of Excel"...Excel file e mail addresses into address group list
I want to take the .csv file from excel into my outlook
express address book then copy addresses (select members)
into a group list.
Then I want to keep that address in the group list, but
erase from the address book.
First back up your Windows Address Book ( .WAB)
Export your address book to a .csv format so that
you are sure you have the formatting correct (all the fields).
When you import your .csv file to the address book, you
must add one more column to your Excel file and fill it
with a single blank. This will generate the need comma
at the end of each row -- fail...How Change default "look in" location in EXCEL for Importing Exte.
I am importing data contained in a text file. When I get to Import Data, the
"Look In" folder location always defaults to "My Data Sources". How do I
change that to the folder where my data is? (files are on my computer).
I've finsihed my spreadsheet and I'm able to lock the cells I don't
want people to mess with.
How do I hide the formulas?
Also, my workbook has more than one sheet. Can I hide formulas in one
sheet, but not the other, etc.? The same would go for locking cells.
On Nov 13, 4:27 pm, Drake <Dr...@Drake37.org> wrote:
> I've finsihed my spreadsheet and I'm able to lock the cells I don't
> want people to mess with.
> How do I hide the formulas?
> Also, my workbook has more than one sheet. Can I hide formulas in one
> sheet, but not ...How do I update Excel 2000 macros to work in Excel 2002?
Working in Excel 2002/XP on an Excel worksheet which was created in Excel
2000, I get an error message "Subscript out of range". How do I update the
macro to work in Excel 2002?
normally the macro should work without a problem. Best to post the part of
your code which generates this error
"BobPetrich" <BobPetrich@discussions.microsoft.com> schrieb im Newsbeitrag
> Working in Excel 2002/XP on an Excel worksheet which was created in Excel
> 2000, I get a...Word 2007 startup slow after installing Windows 7
Why only Word and not Excell and PowerPoint?
Do you have a printer installed?
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Poul Erik" <Poul Erik@discussions.microsoft.com> wrote in message
> Why only Word and not Excell and PowerPoint?
...Convert to word / excel
in access 03, i could run a report then export it to word or excel, however i
cannot seem to be able to do it with access 07, HELP!!
On the ribbon, select the External Data tab. There is an Excel icon on the
> in access 03, i could run a report then export it to word or excel, however i
> cannot seem to be able to do it with access 07, HELP!!