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?

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

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