Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

"Share Workbook" grayed out / unavailable

But only when I have a list.

The help actually says to use lists when sharing a workbook to avoid
conflicts! Why doesn't this work?

From the "About resolving conflicting changes in shared workbooks:"

"To make entering lists easier, Excel allows more than one user to add data
to the row at the end of a list without triggering conflicts. "


Post your answer or comment

comments powered by Disqus
Why is "Share Workbook" grayed out? What do I need to do differently to use
that function? I'm using MS Office Pro 2003

Why is "Share Workbook" grayed out? What do I need to do differently to use
that function? I'm using MS Office Pro 2003

hi,

my hyperlink option is grayed out and i can't figure out why.

currently, the speadsheet is shared. but it wasn't when i first created it. when it *wasn't* shared, i was *able* to create hyperlinks. is it possible that sharing a workbook grays out the hyperlink option?

there is nothing odd about the cell i'm currently trying to hyperlink -- i removed all formatting.

thanks, ankimo

I want to merge an Excel Spreadsheet into a blank Workbook with a lot of
Macros behind the blank Workbook.

The Merge Workbook on the Drop Down Menu is grayed out. I have never worked
with Excel so I am really struggling as to why it is Grayed out and also how
to do the merge.

Help will be greatly appreciated.

Thanks in Advance

Bill

I have a shared workbook. Once in a while, I cannot uncheck the allow
changes by more than one user at the same time. This option in the shared
workbook under the tools menu is grayed out. Other times this option is
available. Can someone please tell me why this option becomes unavailable.

I have created a workbook, an am sharing it with tracked changes, but for
some reason the new record button is grayed out and won't allow any more
changes. If you use the auto form it just replaces the current record with
the info you just typed.
I am stumped! any suggestions?

Joel

My apologies to viewers who have read this post already. I forgot to put a title on my last post.

As part of a string of answers to a previous question (see “Why do I encounter problems running macros in a shared workbook?”), I’m left with the impression that I cannot successfully run macros in a shared workbook if I protect worksheets/workbooks. The reason I’d like to have worksheet protection is that I have many data forms set up and there are some data forms where I do not want users entering or editing existing data fields (sheet protection grays out the cells and the “New” button”). If anyone has successfully protected and unprotected a sheet using a macro in a shared workbook, I’d love to hear about it. I’ve tried setting up some very simple examples and have not been able to get them to work.

I read the Excel help menu on the limitations of workbooks and it does not say that you cannot use protection features on shared workbooks

(From the help menu) In a shared workbook, you cannot do the following:

Passwords
· Assign a password to protect individual worksheets or the entire workbook. Protection that you applied before sharing the workbook remains in effect after you share the workbook.
· Change or remove passwords. Passwords that you assigned before sharing the workbook remain in effect after you share the workbook.
Macros
Write, change, view, record, or assign macros. However, you can record operations in a shared workbook into a macro stored in another workbook that isn't shared. In a shared workbook, you can run macros that were created before you shared the workbook; although if you run a macro that includes an unavailable operation, the macro stops running when it reaches the unavailable operation.

Any comments?

There are several functions that are disabled in the workbook form.
Hyperlink, create list and merge and center are grayed out and can not be
selected. If I open a new workbook this are available to use. The only
difference that I can see between each other is that one is "Shared".

Why can't I access the command to Move or Copy Worksheet once I have shared
the workbook? I had that available until the workbook was shared, and then
it was grayed out. Is there another way to copy a worksheet from a shared
workbook? Thanks for any info.

KK

We have a shared workbook has been acting up lately. It is used primarily by
2 users.

When we went to tools/sharing and looked at who was logged in there were 7
entries. 2 were from the current day but the other so-called "users" were
all of one particular user with dates ranging from a week old to 3 months
old...inactive sessions that excel thinks are current sessions/log ins. What
would that user be doing wrong to be prevented from logging out of the
workbook properly? Why does this spreadsheet think this user is logged in
when clearly he is not? Is this a common excel shared workbook problem? Is
it O.K. to remove the stuck sessions / logins and if so will removing them
have any affect on the database?

I have an excel 2003 file, that is a shared workbook, the file is huge, and I
know if I uncheck and recheck the shared option, it will clear my history and
decrease the file size. but I would like to change the amount of history it
is keeping. (defaulting 30 days) When I go Tools share work advanced
tab. only the keep history for 30 days is grayed out, and all the other
options are availble, I can not figure out why, can anyone please help me

Office 2003 SP3. On all worksheets, my Edit - Delete command is grayed out
(unavailable). I can't delete a row or column. None of the workbooks are
protected or shared. Workbooks are fine on other computers. Any way to
reenable this?

There are several functions that are disabled in the workbook form.
Hyperlink, create list and merge and center are grayed out and can not be
selected. If I open a new workbook this are available to use. The only
difference that I can see between each other is that one is "Shared".

I am using a shared workbook and wanted to conditionally format blank entries however the option is grayed out. Has a user restricted this access or is there something else preventing this? Thanks in advance for any help.

MS Excel 2003 SP2

I'm working with a shared workbook. None of the worksheets are protected nor
is the workbook. For some reason I can't insert an iamge on any of the
worksheets.

When I choose the Insert/Picture option from the tool bar all options after
that are grayed out.

Where else can I check for workbook sttings that would prevent this?

I hope I can get an answer to this question before our project is over. For
now i will need to figure out a work around!

Thanks,
BB

I have an excel 2003 file, that is a shared workbook, the file is huge, and I
know if I uncheck and recheck the shared option, it will clear my history and
decrease the file size. but I would like to change the amount of history it
is keeping. (defaulting 30 days) When I go Tools share work advanced
tab. only the keep history for 30 days is grayed out, and all the other
options are availble, I can not figure out why, can anyone please help me

Why is the merge cells function grayed out in a shared workbook? Anyone got a
fix?

How do I share an Excel wookbook when the tools-shared workbook option is
grayed out?

Hi,

I use excel 2010.

My drama is I have an external data connection to xe.com which updates my exchange rates every 30mins.

My workbook also needs to be shared because more than 2 of us use it to get pricing from the products we sell. This means having to type part numbers into one cell and having it spit out the price in another.

Among other things we also recored customer info into it as well, which gets saved then updated on the other person's excel 15mins later.

So, taking all that into account when I share the workbook all the data tools are grayed out. But my connection to xe.com is still there (according to the connections button).
while shared it will not update the exchange rates every 30mins like it's meant to, but when I unshare it, it works just fine.

Is there a way to have it so it updates while shared?

Unsharing then resharing to update the exchange rate just isn't practical.

Any ideas would be greatly appreciated.

I did try the search function but it was giving me fatal errors, so was unable to see if anyone else has had this problem. sorry if this is the case.

Hi,

I want to be able to check if a user already has a shared workbook open - One of the solutions i can think of would be to create a new tab, and create a list of the users who already have the workbook open, search the username against the list of people with the workbook open, then boot them out if they match more than once

So, is it possible to get the list of the users who have the shared workbook open?

If not, any suggestions of how i can check if the user has the shared workbook open already?

The workbook would be opened in another excel application btw...

I'd be gratefull for any help

Rickie

Hello,

I have been searching for a while on how to update changes from a shared workbook without having to save. I know it has to be possible as when you click on Tools>Track Changes> Accept or Reject Changes.. it automatically refreshes the data from the server copy of the file and posts it on the screen. I have not been able to find a help resource anywhere on VBA code to accomplish a refresh of this sort.

Can anyone help. I have tried the

	VB:
	
ActiveWorkbook.RefreshAll 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I have also tried playing with the update frequency and many other things.

but it does not seem to work.

Any ideas?

If anyone would know the Control ID for "Accept or Reject Changes..." I may be able to figure a few things out. Even the microsoft database doesnt have the control item for this its under Tools>Track Changes>Accept or Reject Changes... any help would be great.

Thank you

There are no macros runing and I have a workbook in which each sheet indicats that it is already protected. I know the password that was used, but since "unprotect sheet" is grayed out, Excel will not allow me to enter the password to unprotect a sheet. Any suggestions?

Is there a way I can code to check if there is a conflict when a user tries to save in a shared workbook? Auto Merged Post Until 24 Hrs Passes;

I figured out a different way of approaching my problem if anyone else is having trouble:

I had the workbook "refresh" itself by using


	VB:
	
ThisWorkbook.AcceptAllChanges 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Then perform whatever needs to be done. I tested it with two people doing it at almost the same time, and no errors were found

Hi all,

I have a problem I can't figure out. I have a protected worksheet with some macros running on it, and I have been requested to make the workbook shared. Trying to implement this, I keep getting the standard "1004 You cannot use this command on a protected sheet" error when applying an autofilter. Here is what is making this problem a little tricky:

- As the workbook is shared, I cannot do Protect UserInterfaceOnly because you can't change the protection settings on a shared workbook without unsharing it. Needless to say, I cannot unshare the workbook.

- When I protect the sheet, I do allow the user to use autofilter. Consequently, Sheet.Protection.AllowFiltering and Sheet.EnableAutofilter both are on. Still, I keep getting the error.

The failing line of code is:

	VB:
	
shData.Range("_filterDataBase").AutoFilter lngField, strArg 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
where shData is the codename of the sheet, lngField is the number of the field and strArg is the filtering criteria.

My guess is, that the error comes from the fact that (for some silly reason) in VBA the .AutoFilter method is used to create a new filter, not only to use an existing one. The members of Sheet.AutoFilter.Filters collection are read-only, and cannot be used to modify the existing filter.

I would be very grateful if somebody could either clarify that using .AutoFilter on a protected worksheet is something that simply cannot be done, or point out what I am doing wrong. Also, if I am wrong in any of my above assumptions of "can't do" nature, please correct me.


No luck finding an answer? You could always try Google.