ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shared workbooks (https://www.excelbanter.com/excel-worksheet-functions/70729-shared-workbooks.html)

Laurie Atchison

Shared workbooks
 
I have made a file containing 10+ excel workbooks. I have made them shared
access. When the others open the file, they can only see 1 of the workbooks.
Why are the rest not viewable for them?

Dave Peterson

Shared workbooks
 
Does this mean you made one workbook with 10 worksheets? And the users can only
see one of the worksheets when they open that workbook?

If yes, do you have any macros running that hides worksheets?



Laurie Atchison wrote:

I have made a file containing 10+ excel workbooks. I have made them shared
access. When the others open the file, they can only see 1 of the workbooks.
Why are the rest not viewable for them?


--

Dave Peterson

Laurie Atchison

Shared workbooks
 
Yes, I have made one workbook with 10 worksheets. And the users can only
see one of the worksheets. I don't believe that I have any macros running to
hide worksheets.

Laurie

"Dave Peterson" wrote:

Does this mean you made one workbook with 10 worksheets? And the users can only
see one of the worksheets when they open that workbook?

If yes, do you have any macros running that hides worksheets?



Laurie Atchison wrote:

I have made a file containing 10+ excel workbooks. I have made them shared
access. When the others open the file, they can only see 1 of the workbooks.
Why are the rest not viewable for them?


--

Dave Peterson



All times are GMT +1. The time now is 10:02 AM.

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