ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get rid of read only that isn't there? (https://www.excelbanter.com/excel-discussion-misc-queries/122447-how-do-i-get-rid-read-only-isnt-there.html)

Susan

How do I get rid of read only that isn't there?
 
This is the problem - last year I created a spreadsheet so that I could do a
mail merge and print labels for my parents Christmas card list. When I try to
save it to a disk so that I can put it on my dad's computer, I get a message
that it is read only. When I check the properites for the file, the read only
is not checked. This drove me nuts last year and is still driving me nuts.

King Harry

How do I get rid of read only that isn't there?
 

Hello Susan,

Did you create a copy straight from the original file?

If not, maybe this can help you.

Open your file, and next save a copy with "save as" without changing
anything in the original file. Make sure that in "Tools/General Options"
every box is empty, and then save. Normally you should be able to copy the
new file to a disk.

I hope this helps you out...

Regards, Wim


"Susan" wrote:

This is the problem - last year I created a spreadsheet so that I could do a
mail merge and print labels for my parents Christmas card list. When I try to
save it to a disk so that I can put it on my dad's computer, I get a message
that it is read only. When I check the properites for the file, the read only
is not checked. This drove me nuts last year and is still driving me nuts.


Susan

How do I get rid of read only that isn't there?
 
Hi, King Harry,
I tried your suggestion but it still comes up that it can't be saved because
it is marked read only. But if you look under properties the "read only" box
is clear. I guess I am doomed to keeping the list on my computer unless
someone else has another suggestion.
Thanks for trying.
Susan

"King Harry" wrote:


Hello Susan,

Did you create a copy straight from the original file?

If not, maybe this can help you.

Open your file, and next save a copy with "save as" without changing
anything in the original file. Make sure that in "Tools/General Options"
every box is empty, and then save. Normally you should be able to copy the
new file to a disk.

I hope this helps you out...

Regards, Wim


"Susan" wrote:

This is the problem - last year I created a spreadsheet so that I could do a
mail merge and print labels for my parents Christmas card list. When I try to
save it to a disk so that I can put it on my dad's computer, I get a message
that it is read only. When I check the properites for the file, the read only
is not checked. This drove me nuts last year and is still driving me nuts.


GTV

How do I get rid of read only that isn't there?
 
Hi Susan,

The reason why you're getting this message is because you're trying to save
the Excel Workbook while the mail merged document is also open. Or it could
be that the workbook is referencing the mail merge document when you open it,
meaning the Word Doc will always have full access to it every time you open
it.

"Susan" wrote:

Hi, King Harry,
I tried your suggestion but it still comes up that it can't be saved because
it is marked read only. But if you look under properties the "read only" box
is clear. I guess I am doomed to keeping the list on my computer unless
someone else has another suggestion.
Thanks for trying.
Susan

"King Harry" wrote:


Hello Susan,

Did you create a copy straight from the original file?

If not, maybe this can help you.

Open your file, and next save a copy with "save as" without changing
anything in the original file. Make sure that in "Tools/General Options"
every box is empty, and then save. Normally you should be able to copy the
new file to a disk.

I hope this helps you out...

Regards, Wim


"Susan" wrote:

This is the problem - last year I created a spreadsheet so that I could do a
mail merge and print labels for my parents Christmas card list. When I try to
save it to a disk so that I can put it on my dad's computer, I get a message
that it is read only. When I check the properites for the file, the read only
is not checked. This drove me nuts last year and is still driving me nuts.


Susan

How do I get rid of read only that isn't there?
 
Hi GTV,
I don't think this is the case. First of all, I have never saved the mail
merge document. If I were to open the Excel file right now and tried to save
it to a disk, it will tell me that it is read only and won't let me do
anything to it. I just can't see how if Word isn't even running how that
could have an effect on the Excel document. Maybe I don't understand how
these things work.
Susan

"GTV" wrote:

Hi Susan,

The reason why you're getting this message is because you're trying to save
the Excel Workbook while the mail merged document is also open. Or it could
be that the workbook is referencing the mail merge document when you open it,
meaning the Word Doc will always have full access to it every time you open
it.

"Susan" wrote:

Hi, King Harry,
I tried your suggestion but it still comes up that it can't be saved because
it is marked read only. But if you look under properties the "read only" box
is clear. I guess I am doomed to keeping the list on my computer unless
someone else has another suggestion.
Thanks for trying.
Susan

"King Harry" wrote:


Hello Susan,

Did you create a copy straight from the original file?

If not, maybe this can help you.

Open your file, and next save a copy with "save as" without changing
anything in the original file. Make sure that in "Tools/General Options"
every box is empty, and then save. Normally you should be able to copy the
new file to a disk.

I hope this helps you out...

Regards, Wim


"Susan" wrote:

This is the problem - last year I created a spreadsheet so that I could do a
mail merge and print labels for my parents Christmas card list. When I try to
save it to a disk so that I can put it on my dad's computer, I get a message
that it is read only. When I check the properites for the file, the read only
is not checked. This drove me nuts last year and is still driving me nuts.



All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com