Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Access data on spreadsheet without accessing the file?...

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other people
who need some of the information on one tab of the worksheet, but they are
not allowed access to the file. I have been asked to come up with a way to
make this happen.

And I can't be accomplished by just allowing access to the one tab they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they need,
but the problem with that is that there is a lookup on the tab they need
access to, where they put in an ID number and it populates the other fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone out
there may have some ideas.

Thanks.

  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 515
Default Access data on spreadsheet without accessing the file?...

Have you tried using an inputbox, to insert the relevant value in the main
sheet?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Dan Brimley" wrote:

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other people
who need some of the information on one tab of the worksheet, but they are
not allowed access to the file. I have been asked to come up with a way to
make this happen.

And I can't be accomplished by just allowing access to the one tab they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they need,
but the problem with that is that there is a lookup on the tab they need
access to, where they put in an ID number and it populates the other fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone out
there may have some ideas.

Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 9
Default Access data on spreadsheet without accessing the file?...

no, I haven't. I will look into that. Could you tell me more about how to
do that?
Thanks.


"kassie" wrote in message
...
Have you tried using an inputbox, to insert the relevant value in the main
sheet?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Dan Brimley" wrote:

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other
people
who need some of the information on one tab of the worksheet, but they
are
not allowed access to the file. I have been asked to come up with a way
to
make this happen.

And I can't be accomplished by just allowing access to the one tab they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they
need,
but the problem with that is that there is a lookup on the tab they need
access to, where they put in an ID number and it populates the other
fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone out
there may have some ideas.

Thanks.


  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 515
Default Access data on spreadsheet without accessing the file?...

Hi Dan
I did not try this out, but what I would think, is that you would use a
macro, which would create a variable to hold the value you are asking for,
and then do
screenupdating = false, so as not to show the master sheet
your variable = Inputbox("Enter the ID you wish to use")
specific cell address = your varable
close the main file
screenupdating = true

--
Hth

Kassie Kasselman
Change xxx to hotmail


"kassie" wrote:

Have you tried using an inputbox, to insert the relevant value in the main
sheet?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Dan Brimley" wrote:

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other people
who need some of the information on one tab of the worksheet, but they are
not allowed access to the file. I have been asked to come up with a way to
make this happen.

And I can't be accomplished by just allowing access to the one tab they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they need,
but the problem with that is that there is a lookup on the tab they need
access to, where they put in an ID number and it populates the other fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone out
there may have some ideas.

Thanks.

  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 9
Default Access data on spreadsheet without accessing the file?...

ok, thanks Kassie. I'll see what I can figure out.
I appreciate your help.


"kassie" wrote in message
...
Hi Dan
I did not try this out, but what I would think, is that you would use a
macro, which would create a variable to hold the value you are asking for,
and then do
screenupdating = false, so as not to show the master sheet
your variable = Inputbox("Enter the ID you wish to use")
specific cell address = your varable
close the main file
screenupdating = true

--
Hth

Kassie Kasselman
Change xxx to hotmail


"kassie" wrote:

Have you tried using an inputbox, to insert the relevant value in the
main
sheet?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Dan Brimley" wrote:

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other
people
who need some of the information on one tab of the worksheet, but they
are
not allowed access to the file. I have been asked to come up with a
way to
make this happen.

And I can't be accomplished by just allowing access to the one tab they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they
need,
but the problem with that is that there is a lookup on the tab they
need
access to, where they put in an ID number and it populates the other
fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file
to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone
out
there may have some ideas.

Thanks.




  #6   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 9
Default Access data on spreadsheet without accessing the file?...

I'm not having any luck figuring this out. Could someone give me an example
of the code I might use and how to accomplish this.

Thank You so much.


"kassie" wrote in message
...
Hi Dan
I did not try this out, but what I would think, is that you would use a
macro, which would create a variable to hold the value you are asking
for,
and then do
screenupdating = false, so as not to show the master sheet
your variable = Inputbox("Enter the ID you wish to use")
specific cell address = your varable
close the main file
screenupdating = true

--
Hth

Kassie Kasselman
Change xxx to hotmail


"kassie" wrote:

Have you tried using an inputbox, to insert the relevant value in the
main
sheet?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Dan Brimley" wrote:

Hi,

I have built a large, complicated spreadsheet with highly sensitive
information. It is only accessed by a few people. There are other
people
who need some of the information on one tab of the worksheet, but they
are
not allowed access to the file. I have been asked to come up with a
way to
make this happen.

And I can't be accomplished by just allowing access to the one tab
they
need. They can have NO access to open the file at all.

I thought of creating a separate worksheet that links to the info they
need,
but the problem with that is that there is a lookup on the tab they
need
access to, where they put in an ID number and it populates the other
fields
on that worksheet from other worksheets in the file. So if they had a
linked worksheet, how would it pass the ID number to the original file
to
populate the fields?

I hope this is making atleast some sense. I was just hoping someone
out
there may have some ideas.

Thanks.



  #7   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default Access data on spreadsheet without accessing the file?...

"Dan Brimley" wrote...
....
There are other people who need some of the information on one tab
of the worksheet, but they are not allowed access to the file. I
have been asked to come up with a way to make this happen.

And I can't be accomplished by just allowing access to the one tab
they need. They can have NO access to open the file at all.

....

That so, there's NO way to do this without saving only the data these
nonprivileged users need in a separate file they can access.

That is, they can't get ANYTHING from any file for which they lack
operating system READ permission, but if they have OS read permission
to an .XLS file, they can open it in Excel.

I thought of creating a separate worksheet that links to the info
they need, but the problem with that is that there is a lookup on
the tab they need access to, where they put in an ID number and it
populates the other fields on that worksheet from other worksheets
in the file. So if they had a linked worksheet, how would it pass
the ID number to the original file to populate the fields?


This makes it a practical impossibility. Excel doesn't provide this
kind of security/protection. If your nonprivileged users need access
to sensitive data in the sensitive workbook, they need to be able to
open the workbook. If they can open the workbook, Excel provides no
robust protection to prevent them from unprotecting the workbook or
any worksheets.

What you need for this sort of thing is a database running on a server
that would allow nonprivileged users to run stored procedures that
would run queries against tables of sensitive data using different,
broader permissions than the nonprivileged users possess. The
nonprivileged users would see the query results but would have no
direct access permissions to the tables.

It MIGHT be possible to hack something like this using Excel Services,
but I don't have any idea how to do that. If you're not an IT
department developer, this may be something you can't do yourself, but
it might be something your IT department could do.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access data on spreadsheet without accessing the file?... Dan Brimley Excel Discussion (Misc queries) 6 May 25th 07 07:27 AM
Accessing Attached xls File shannyshanhan Excel Worksheet Functions 0 August 9th 06 10:04 PM
create excel spreadsheet on a data access page Pitu Excel Discussion (Misc queries) 0 October 3rd 05 08:11 PM
Linking Data in Access to a Spreadsheet carrol Links and Linking in Excel 4 July 21st 05 11:12 PM
Paste Access data into Excel spreadsheet JDM Excel Discussion (Misc queries) 1 April 29th 05 05:42 PM


All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"