How do I copy a worksheet tab in a shared workbook?

D

dano1352

New Member
Joined
Jan 11, 2019
Messages
11
I want to duplicate a worksheeet (Tab) within a shared workbook? When I try it the conventional way by right clicking on the tab a message pops up that says it's not allowed in a shared workbook.

Thanks.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
That's one of the many limitations of a shared workbook. You'd have to unshare it, copy the tab, then share it again.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
470
Amo840812
A
L
  • Solved
Reference a sheet based on cell value
Replies
4
Views
170
6StringJazzer
6StringJazzer
S
  • Question Question
Record macro that includes creating a macro
Replies
4
Views
120
Sheripres
S
G
  • Question Question
User-defined type not defined when clicking on a Hyperlink that leads to a hidden tab
Replies
5
Views
151
Micron
M
E
  • Question Question
Copy data from a Data Entry form's table to the correct date in another tab
Replies
0
Views
334
Exceleration65
E

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top