Free Microsoft Excel 2013 Quick Reference

Excel problem with editing in a PowerPoint Presentation

I'm not sure which discussion group this applies to, so I'm posting it in
both Excel and PowerPoint.

I am using Office 2003 and I just started having problems with any Excel
workbooks embedded into a PowerPoint presentation. It is a bit difficult to
describe but I'll give it my best shot.

Whenever I double-click an Excel object to edit the data, it opens up like
normal and gives me all of the MS Excel options I normally get. But what is
very VERY strange is that when I try to select a single cell (or row/column),
it will take me into the MS Excel program and not allow me to edit anything
in the PowerPoint. The same thing happens when the pasted data is an Excel
Chart or pivot table.

Has anyone ever heard of anything like this and if so, what is the fix?? If
I have to, I'll uninstall MS Office and reinstall it but I'm trying to avoid
that.

Thanks in advance to anyone who can help.
Frank


Post your answer or comment

comments powered by Disqus
Without complex visual basic is there any way to hyperlink from an Excel 2007
cell, to slide number [whatever] in a Powerpoint presentation?

Hi guys - I'm new to this forum - I think I'm going to enjoy wading through the tips in here. I've been doing advanced Excel design and VBA programming since 1998 but haven't come across this site before.

Anyway - I have a problem.
When using Office 97 I wrote a suite of macros for my employer which was designed to write variable query strings to apply to imported data, which would then be squirted into user-defined chart areas, cycle each 'variable' variable (and all combinations thereof), copy the chart containing the data that matches, and paste into an output sheet as a metafile.

This was used to produce charts and tables for a survey whereby each participant needed a comparison of their data vs. everyone else EXCEPT theirs. This meant every table and chart in every copy of the report was unique.

I expanded this on user request to contain an option to throw out the metafiles to slides in a newly created Powerpoint file instead of just piling them up in an Excel worksheet, along with all its possible page setup/page break problems.

This worked great until I hit Office XP. The problem occurs when creating a Powerpoint Presentation object from VBA, because when it does so, the object contains an empty powerpoint window with task pane - i.e. there is no active 'presentation' window. For some reason it even seems impossible to 'Add' a presentation object to the application because there is no ActiveWindow.

Similarly, Powerpoint (along with Excel) doesn't allow you to 'add window' - i.e. you can't do Application.Windows.Add - you can only do ActiveWindow.NewWindow - i.e. you can add a window with reference to an existing window - but not if there is no existing window.

I've tried and tried and can just not start a Powerpoint XP object with a window to control the rest of the application and add presentations, slides etc. Even turning the Task Pane off doesn't help because the app object simply contains a blank window (which doesn't count as an ActiveWindow) reading 'Click here to create slide'. It is only when the user manually clicks on this area, that an ActiveWindow is then created.

How do I get past this so that I don't have to make the application visible and wait for the user to manually click in the centre of the screen to create an ActiveWindow? I want the process to remain transparent and interaction-free as it was pre-XP.

Many thanks to anyone who can help.

Best Regards,
Mark Boulton
London

Hi guys - I'm new to this forum - I think I'm going to enjoy wading
through the tips in here. I've been doing advanced Excel design and
VBA programming since 1998 but haven't come across this site before.

Anyway - I have a problem.
When using Office 97 I wrote a suite of macros for my employer which
was designed to write variable query strings to apply to imported data,
which would then be squirted into user-defined chart areas, cycle each
'variable' variable (and all combinations thereof), copy the chart
containing the data that matches, and paste into an output sheet as a
metafile.

This was used to produce charts and tables for a survey whereby each
participant needed a comparison of their data vs. everyone else EXCEPT
theirs. This meant every table and chart in every copy of the report
was unique.

I expanded this on user request to contain an option to throw out the
metafiles to slides in a newly created Powerpoint file instead of just
piling them up in an Excel worksheet, along with all its possible page
setup/page break problems.

This worked great until I hit Office XP. The problem occurs when
creating a Powerpoint Presentation object from VBA, because when it
does so, the object contains an empty powerpoint window with task pane
- i.e. there is no active 'presentation' window. For some reason it
even seems impossible to 'Add' a presentation object to the application
because there is no ActiveWindow.

Similarly, Powerpoint (along with Excel) doesn't allow you to 'add
window' - i.e. you can't do Application.Windows.Add - you can only do
ActiveWindow.NewWindow - i.e. you can add a window with reference to an
existing window - but not if there is no existing window.

I've tried and tried and can just not start a Powerpoint XP object with
a window to control the rest of the application and add presentations,
slides etc. Even turning the Task Pane off doesn't help because the
app object simply contains a blank window (which doesn't count as an
ActiveWindow) reading 'Click here to create slide'. It is only when
the user manually clicks on this area, that an ActiveWindow is then
created.

How do I get past this so that I don't have to make the application
visible and wait for the user to manually click in the centre of the
screen to create an ActiveWindow? I want the process to remain
transparent and interaction-free as it was pre-XP.

Many thanks to anyone who can help.

Best Regards,
Mark Boulton
London

--
BizMark

Ok, I've got my super-whizzy Powerpoint presentation up and running and several of the slides feature Excel data and charts flying in and out.

The source Excel files live in a directory called (originally) Excel source. If next month I change the data in the source files and then re-run the PowerPoint presentation, will the updated data appear?

All replies appreciated.

EMERGENCY!!! I'm working on a PowerPoint presentation and I need to insert an
Excel spreadsheet with five pages into a slide. I have linked to documents in
the past but cannot get this to work. Also, I'd like to have the excel file
in the slide updated when the Excel file is updated. Please help! Thanks!
b

Linking PowerPoint data into Excel has many limitations. A good tool
that may work for you is xpport. It reads your print areas and
therefore can copy multiple tables and charts from multiple sheets in
your xls file to PowerPoint with a single click. Let me know how it
works for you.
Rich

JRPK Wrote:
> I'm having a problem regarding linking several Excel charts and tables
> from a single Excel file into a PowerPoint Presentation.
> Example:
> I create a chart on tab #1 of the Excel file and paste-link it into
> slide #1 in the PowerPoint file.
> Then I copy the tab (and call it tab #2) in the same Excel file but
> change the data and paste link the chart on tab #2 of the Excel file
> into slide #2 in the PowerPoint file.
> Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . .
>
> Now lets say I update the data in the chart on Tab #2 in the Excel
> file and go to PowerPoint to update it.
>
> It will now convert all the charts in the PowerPoint file to the chart
> on tab #2. It seems when I update the links, whatever tab is showing
> (in this case the chart on tab # 2) on screen in the Excel file will
> then be reflected in every link in the PowerPoint file. It's as if it
> ignores the links to the designated spread sheets and simply looks to
> the Excel file to see what it currently looks like.
>
> Am I doing something wrong? Do I actually have to create and format a
> brand new chart on a brand new tab everytime I want to link multiple
> charts. Copying tabs but individually linking them seems like it
> should work.
>
> If it's of any help, both PowerPoint and Excel are XP versions.
>
> Any help would be greatly appreciated.
>
> Thanks!
>
> JRPK

--
Rich

Hi,
I was not sure where to post this because I do not know what kind of macro is the best to handle this

We would like to show a chart in PowerPoint that is dynamic. I am not sure if this is an excel macro, a PowerPoint macro, or some kind of Excel embedded in PowerPoint running in the background.

What we want to do is take a chart of several items that appear or disappear from the chart when a checkbox form or activex control is checked. We want this to work in presentation mode of PowerPoint. We want to be able to show the audience all the items and be able to select any order or combination of items and have the chart change based on those selections.

A picture is worth a thousand words so I have included an excel file that generically shows what I am trying to do.

I guess my first question is can I make this excel functionality from my file appear in a PowerPoint presentation and be able to check the boxes while presenting? Anyone know if this is possible or how to do this?

Hi everyone,

I have put some macro's in a powerpoint presentation I have made, at the end I have some questions for users to answer with mulitple choice answers and different macro's run based on which choice they make.

The problem I am having is that after I save and re-open the file the macro's that were previously working fine stop working, I have tested it with a blank presentation and place a button in it that brings up a msgbox when clicked and the same problem occurs, after saving it, next time it opens the macro won't run,

does know how to fix this or why it may be happening?

Jon Smith

Hi

am facing problems with links in shared excel sheets.

My first question is,
Does linking to another sheet increase the size of the workbook??
if so is it possible to reduce the size without removing the links.?

The size of the shared excel which i use are in the range of 30- 40 MB(this might be due to the linking). now if such a big sheet is open, it doesnt allow me to open any other excel sheet . an error message is displayed saying it does not have enough resources.

request you all to help me in these issue and help me in reducing size of excel sheets with links.

thanks

Hi,
I have an excel sheet which keeps getting updated every month. I need to create a powerpoint presentation based on the data captured in this sheet. Is there any method of doing it?
TIA
Shilps

Hi,

I will do my best to describe my problem, I hope it is clear.

At the moment I have a workbook, which contains a summary sheet (along with 20 or so other sheets). The summary sheet contains a dropdown box which contains project codes, the value in this drop down box is used by several Vlookup functions to generate the summary sheet.

What i need to do is basically cycle through the drop down box, capture the summary sheet for each project, and "export" each of these summaries to a powerpoint presentation.

The issue is:
1. The summary is based upon the drop down box and is generated on a single worksheet, which changes upon the selection of the drop down box. So i need to maybe loop through capturing each summary.

2. Getting each of those summaries to individual slides in a powerpoint.

I am new to this job, and am in over my head some what, so any assistance is greatly appreciated.

Regards,

JuniorInTheDeep

Hi All,

Can anybody help me out by telling me hw can i transfer data from a range in an excel sheet to a powerpoint presentation??????

Thanks to all in advance!!!!!!

Hi everybody, im pretty new to VBA programming, but i couldn't find solution to my problem in any online tutourial. Also, english is not my native language, so forgive me any mistakes.

This is what I wrote:
Sub Rew()
Dim i As Integer
For i = 1 To 50
        Names.Add "function", RefersTo:=Range("o11").Offset(i - 1)
        Names.Add "variables", RefersTo:=Range("b11:b60").Offset(i - 1)
        Names.Add "constraint", RefersTo:=Range("i11:i60").Offset(i - 1)
        Range("r10").Value = i
        SolverOk SetCell:="function", MaxMinVal:=1, ByChange:=Range("variables")
        SolverAdd CellRef:=Range("constraint"), Relation:=2, FormulaText:="1600"
        SolverAdd CellRef:=Range("variables"), Relation:=3, FormulaText:="0"
        SolverSolve UserFinish:=True
        SolverFinish KeepFinal:=1
        Range("r11").Offset(i - 1).Value = Range("o11").Offset(i - 1).Value
Next i
End Sub
Basicly my intention was to write a macro that uses Solver in a loop, but in every iteration changes Target Cell and "shrinks" range of cells in ByChange and in constraints - in first iteration it should maximise O11 for constraints b11:b60 <= 0 & i11:i60 = 1600, in a second iteration maximise O12 for constraints b12:b60 <= 0 & i12:i60 = 1600 etc. for 50 iterations. I wanted to add .Resize(-1,0), after every Offset(i - 1), but than Excel messages me with error, but thats the minor deal.

Major problem is, that solver doesen't work in that loop, I mean when I use it "manually" it can find result for first iteraion, but when I run the macro it just leaves ByChange cells unchanged.

(if you're curious - it should simulate time-inconsistent consumer with "myopia", that choses some consumption path in period i=1 and than revaluates his discounted utility in each of next periods and constantly changes his decisions).
I use Excel 2007.

I created a graph in a macro in excel. The graph is animated in that when a scan button is clicked, the lines in the graph move. I want to use the moving graph in a powerpoint presentation. I am asking for suggestions as to the procedure to do this. Thanks.

I have a TextBox that has MultiLine=True and WordWrap=True. I have 2-fmScrollBarsVertical. The TextBox in on a Page in a MultiPage. When the UserForm comes up, the ScrollBar isn't there. When I click on the TextBox, the ScrollBar appears. How can I fix this?

The other problem is that when they DO come up, the are initially scrolled all the way to the bottom. How do I get them to initialize at the top?

_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.

[ This Message was edited by: phantom1975 on 2002-11-16 01:25 ]

[ This Message was edited by: phantom1975 on 2002-12-21 02:50 ]

I would like to present a chart that has 3 columns of data with each column
being the same height and each column being split into different components
(i.e. a 'typical' 100% stacked column chart). Each column represents a
different market (split between the players in that particular market) and
the markets are of diferent size. What I would like to do is make the width
of each column vary depending on the size of the market. Effectively the
height of the columns is the same and the vertical splits reflect the
relative size of the components within each column but in addition I would
like the width of the columns to reflect the relative size of each market. I
have seen this in a Powerpoint presentation before but assume it was lifted
from Excel. I have Office 2007.

I am attempting to paste an excel data table in a powerpoint slide but once
pasted, the data is cut off. If I double click and enter the excel data
table and resize the window from Powerpoint, the same data shown simply
stretches to the new size. I have tried numerous ways of pasting from the
excel sheet and it still acts the same. I tried a new workbook and was able
to resize correctly. But to recreate all of the data and formulas in a
different workbook would be difficult. Is there a setting or something in
excel that is not allowing me to resize this particular workbook?

Thanks ahead of time for your help!

Hello everyone.

I was wondering if there is anyway to associate pictures with items in a list. Let me explain a little.

I need to make pictures change according to what the user selects in a list.
Ex: User selects item #1, picture associated to item #1 appears in the top left corner, item#2, picture #2 in top left corner, etc.

I tried using a normal search function but found out you can't associate a picture to a cell (or maybe????) so can't use a search function to associate a picture to the item as I did with the price. Is there any way to do it?

Edit : Using excel 2007 *

XL97: Calculation Problems with Arrays in Custom Functions

When you use a custom function in a workbook, the function may return incorrect values. Recalculating the workbook may also take longer than it does in earlier versions of ...

I am trying to get excel to look up in a range of cells I54:I102 to search
for a specific text "improved" and if true put a numerical value in another
cell. I can get it to work if I put it in the first cell but if I put it in
any other cell it returns with an error. What is the best formula to use in
this instance?

Thanks very much.

Can I merge data from Excel or Word document into a PowerPoint presentation.
I know I can cut and paste individual entries but can I merge all information/

Excel updated with links in between destination files:

Situation:

Document A : Master file with raw data

Doc B : file linked to cells in doc A (let's say doc B is for January)

Doc C : file linked to cells in doc A, exactly as doc B but for a
timeframe different, let's say doc C is for February

Let's say Doc B is updated in January and Doc C in February. Doc A has
new raw data in between both files. Saved both file at the time they
were updated.

If we open in March both file (B and C), the second file open will
update automatically the first file we open. Let's say we open B then
C, the C doc will update the B file without asking to do so.

Even if the original file A is deleted at the end of February (and
therefore after B and C have been updated). The B and C doc will
recognise the links from each other and assume that the second file
that is open is the most updated one….but we do not want to update the
first file (January) as the data was ok at the time.

Basically, Excel recognises that the new file as the same links and
decide to update with this information even though that is not the
source data.

Paste-Value is not an option nor is break links as the file
(spreadsheet) is protected.

Is there an option in excel to prevent from updating the links
automatically and without asking first. At least if it would ask (for
approval) before doing so.

Thanks

Pascal

060809 test for minimum #, exlude line with "x" in a column.

hi, I am trying to test a range for the minimum number, but to exclude rows
that have an "x" in a specific problem. thanks.

starting with:
=INDEX(ROW(BU681:BU1159),MATCH(MIN(BU681:BU1159),B U681:BU1159,0))

not working, get FALSE, need row number of next "min" number
=AND(G681:G1159"x",INDEX(ROW(BU681:BU1159),MATCH (MIN(BU681:BU1159),BU681:BU1159,0)))

similar equation have working is:
=SUMPRODUCT(--(LEFT($AX$56:$AX$1159,1)="x"),--($G$56:$G$1159"x"))

Office 2007 Excel problem with windows system local

There is a problem with MS office 2007 Excel ! when i set my windows local setting from "Control Panel ->change keyboard and other input methods ->Administrative Tab ->Change system local" and set to persian everytime I'm closing the Excel it's Not Responding and all of my added data is gone !!

Please Help me

Thanks
Microsoft Certified System Engineer 2003


No luck finding an answer? You could always try Google.