Help!

Reopening will cause any changes you made to be discarded.

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links RSS
Next:  MS Project Links to Excel  
Author Message
David.
External


Since: Jul 27, 2004
Posts: 1



PostPosted: Wed Jul 28, 2004 1:27 am    Post subject: Reopening will cause any changes you made to be discarded.
Archived from groups: microsoft>public>excel>links (more info?)

Hi,

A number of people are having issues with opening a powerpoint
presentation with linked excel graphs in it. At present there a 5
graphs that are linked. They were link by copying the excel graph and
pasting them into powerpoint as a link. The first time you open the
presentation the first link updates fine but the other four give an
excel message: MyExcelFile.xls is already open. Reopening will cause
any changes you made to be discarded. Do you want to reopen
MyEsxcelFile.xls? If I close the powerpoint presentation and check
for running processes, excel is still there. It seems to be trying to
open the same sheet 5 times (once for each link).

I have searched the groups for this type of problem but none of the
suggestions work. I thought I had the answer in another thread
referring to a registry key
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command. If the default
value had a %1 at the end of it, removing it would fix the problem.
My value doesn't have this %1 so it doesn't apply.

I am using Office XP pro SP2 with WinXP Pro SP1. Has anyone had this
problem before and resolved the problem?

regards

David.
Back to top
Bill Manville
External


Since: Jul 30, 2004
Posts: 542



PostPosted: Wed Jul 28, 2004 1:25 pm    Post subject: Re: Reopening will cause any changes you made to be discarde [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If you don't need the link to be a live one then just copy pictures of
the charts from Excel and paste into PowerPoint. You could make a
macro to do this for you which you could run after updating the
workbook (or automatically on saving the workbook).

But if you really need it to be live; we can't change what PowerPoint
does - if it is going to open the file 5 times then can we stop Excel
from complaining about the file being open already?

If you are getting that message it will usually be because on opening
the workbook changes are being made to it. Either by a macro or by a
function (like TODAY() or NOW()) in a worksheet formula.

If you can eliminate these changes on open then the message should not
appear.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum