Home

Wordpad docs embedded in Excel worksheet - limitations? Stability?

%3CLINGO-SUB%20id%3D%22lingo-sub-808268%22%20slang%3D%22en-US%22%3EWordpad%20docs%20embedded%20in%20Excel%20worksheet%20-%20limitations%3F%20Stability%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808268%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%20First%20time%20poster%20here.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20maintain%20a%20Table%20(in%20a%20worksheet)%20that%20contains%20embedded%20Wordpad%20documents%2C%20into%20which%20I%20enter%20notes%20related%20to%20the%20particular%20issue%20(i.e.%20row)%20that%20contains%20it.%26nbsp%3B%20It's%20better%20than%20trying%20to%20keep%20a%20running%20list%20of%20comments%20and%20notes%20directly%20within%20a%20cell%2C%20as%20I'm%20working%20an%20actual%20text%20editor.%20The%20icons%20representing%20each%20Wordpad%20doc%20are%20stuck%20to%20the%20cell%20they're%20in%2C%20so%20I%20can%20sort%20and%20filter%20the%20Table%20at%20will%2C%20and%20the%20Wordpad%20documents%20travel%20with%20the%20rest%20of%20the%20data.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20Wordpad%20document%20is%20treated%20as%20an%20Object%2C%20and%20so%20far%20I%20have%20several%20hundred%20embedded%20in%20the%20worksheet.%26nbsp%3B%20But%2C%20I'm%20afraid%20that%20I'm%20doing%20something%20a%20bit%20out%20of%20the%20ordinary%20here%2C%20and%20I'm%20concerned%20about%20the%20file%20remaining%20stable.%26nbsp%3B%20It%20does%20have%20a%20few%20quirks%2C%20e.g.%20it%20will%20open%20as%20soon%20as%20I%20hover%20my%20cursor%20over%20the%20icon%20in%20File%20Explorer%2C%20and%20it%20will%20often%20open%20%22Copy%20of%22%20and%20%22Copy%20of%20Copy%20of%22%20instances%20if%20the%20cursor%20is%20left%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20there's%20a%20limit%20on%20the%20number%20of%20embedded%20Wordpad%20documents%20(or%20other%20Objects)%20one%20can%20have%20in%20a%20worksheet%3F%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Anyone%20know%20of%20any%20other%20reason%20why%20this%20may%20be%20an%20unorthodox%20or%20otherwise%20risky%20practice%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20feedback%20will%20be%20appreciated.%3C%2FP%3E%3CP%3E-MC%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-808268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
mcygan
Occasional Visitor

Hi!  First time poster here.  

 

I maintain a Table (in a worksheet) that contains embedded Wordpad documents, into which I enter notes related to the particular issue (i.e. row) that contains it.  It's better than trying to keep a running list of comments and notes directly within a cell, as I'm working an actual text editor. The icons representing each Wordpad doc are stuck to the cell they're in, so I can sort and filter the Table at will, and the Wordpad documents travel with the rest of the data.   

 

Each Wordpad document is treated as an Object, and so far I have several hundred embedded in the worksheet.  But, I'm afraid that I'm doing something a bit out of the ordinary here, and I'm concerned about the file remaining stable.  It does have a few quirks, e.g. it will open as soon as I hover my cursor over the icon in File Explorer, and it will often open "Copy of" and "Copy of Copy of" instances if the cursor is left there.

 

Does anyone know if there's a limit on the number of embedded Wordpad documents (or other Objects) one can have in a worksheet?    Anyone know of any other reason why this may be an unorthodox or otherwise risky practice?  

 

Any feedback will be appreciated.

-MC

 

 

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
AIP limitatations with groups
Stefan Nordberg in Azure Information Protection on
0 Replies