#1
|
|||
|
|||
Workbook transferred to another computer, keeps opening as "read-only"
I can't find a good solution through searching, so here is my problem. I have a spreadsheet that I need to save on a thumbdrive and place in a different computer (computer 2), so it can run the solver vba routine, etc. When I open it on computer 2, it says "read-only". I can go into the Trust Center and allow the specific folder, etc., but it doesn't help because I can't save it! So those new "allowed folders" aren't recorded. I suppose I could do a Save As, as the little message suggests, and give it a different name. Supposedly, this newly-named workbook would NOT be read-only. However, I'll be needing to do this a lot, and I don't want the added confusion of always having to do a Save-As on computer 2, then reopen it and start crunching.
To summarize, surely there is something I can do on my original workbook on computer 1, so that it will be trusted by computer 2, and open normally? I am using Excel 2007 on both machines. Thanks for any help! Rick |
#2
|
|||
|
|||
Update from OP...SOLVED
Okay, I made the Trust Center changes in the document on computer 1 (duh). I created a folder on computer 2 (and temporarily on comp 1 so I could choose it), then added that path as a trusted source (including subfolders!). Then I saved it on comp 1. Fortunately, Excel isn't smart enough to know or care what computer that path is on. So, when the file gets over to comp 2, in a subfolder of the "trusted path", it opens normally, in trusted mode. If anyone sees any potential pitfalls with this, or has a better way, please post. Thanks a lot.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word document attached to email is opening as "Read Only" | Jo Freeman | Outlook | 0 | 05-18-2016 02:49 AM |
Outlook "Read Email" Window: ESC doesn't close? | ShankedS | Outlook | 0 | 11-17-2015 09:55 AM |
Message "Unable to read file" when clicking on the Excel icon | roundman | Excel | 3 | 12-03-2014 04:28 PM |
marking email as "read" until email is read on local device. | mwomack | Outlook | 2 | 07-16-2011 08:21 PM |
Outlook 2007 - Receiving Multiple "read receipts" from a single email | garp2100 | Outlook | 1 | 12-03-2010 07:10 AM |