 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / June 2005Embedded Spreadsheets
Hello, I have several documents that have excel spreadsheets embedded in them. The problem I am having is that for some reason after the spreadsheets are accessed, they become corrupt and can not be accessed. I can not figure out what is causing the spreadsheets to get corrupted.... Any help or thoughts on this would be appreciated. thanks G'day jag <jag@discussions.microsoft.com>, Don't embed, link :-) Steve Hudson - Word Heretic steve from wordheretic.com (Email replies require payment) Without prejudice jag reckoned: >Hello, >I have several documents that have excel spreadsheets embedded in them. [quoted text clipped - 5 lines] > >thanks > G'day jag <jag@discussions.microsoft.com>, > [quoted text clipped - 18 lines] > > I do not want to link them because I want to keep the main spreadsheets unedited. Is there any other way to do this? Hi =?Utf-8?B?amFn?=, > I have several documents that have excel spreadsheets embedded in them. > The problem I am having is that for some reason after the spreadsheets are > accessed, they become corrupt and can not be accessed. > I can not figure out what is causing the spreadsheets to get corrupted.... Which version of Word do you have? What message are you getting that makes you think they're corrupt? If you boot Windows in SAFE MODE, so that things like anti-virus plug-ins and management software is disabled, do they behave correctly? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) > Hi =?Utf-8?B?amFn?=, > [quoted text clipped - 17 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) The message says that the file has been corrupted. After you hit OK, you cannot get back into the srpeadsheet object to edit it. We have used them this way for several years without this much problem. They would occasionally get this corruption problem, but not as much as they have lately. The only thing I did differently was to position them with a tight wrap and center the object on the page. Last time they were In line with text. No, we haven't tried booted to Windows Safe Mode yet. Thanks. Hi =?Utf-8?B?amFn?=, > The message says that the file has been corrupted. After you hit OK, you > cannot get back into the srpeadsheet object to edit it. We have used them [quoted text clipped - 3 lines] > wrap and center the object on the page. Last time they were In line with > text. OK, if Safe Mode doesn't make any difference (after reading this, I don't expect it would), then go back to inserting them in-line with the text. Put them in a Table, or a Frame (from the Forms toolbar) in order to get the positioning and text-flow. See if that helps settle things down. If it doesn't, then you may be looking at some kind of problem occurring when the Word document is saved. A bad network connection, for example. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) > Hi =?Utf-8?B?amFn?=, > [quoted text clipped - 21 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) Thanks for the help. I am realigning them to In Line with text. I tried inserting a frame as you said, but it seems to override it when I bring in the object. I have tried it both ways: Copy and Paste Special as an embedded Excel Object and Insert, Object from file. I prefer to use the Insert, Object from file option, but it seems to make the spreadsheet too small and brings in more of a right margin than I like. Hi =?Utf-8?B?amFn?=, > I tried > inserting a frame as you said, but it seems to override it when I bring in > the object. After you've formatted it as in-line, you should be able to move it into the frame so that you get text-wrap capability. Some versions of Word default to in-line, others to text wrap, and in 2003 you can choose your default. > I have tried it both ways: Copy and Paste Special as an embedded > Excel Object and Insert, Object from file. I prefer to use the Insert, > Object from file option, but it seems to make the spreadsheet too small and > brings in more of a right margin than I like. Both approaches give you the same end result (as far as what Word is storing), so use the one the works best for you. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.