Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
add ins
- Thread starter jpadie
- Start date
LaurieHamlin
Programmer
What versions are you using? You seem to asking about creating an Excel workbook?
- Thread starter
- #3
hello Laurie
the end solution needs to be compatible with excel 2010 and later.
not looking to create a workbook at all. what i am looking to do is find an ironclad, totally secure, method of providing highly sensitive data to workbooks for staff to use but not see (the raw data), copy, change etc etc.
and it needs to be maintainable.
i appreciate that MS tools are not the best for this. I'm trying to work out whether I can get anywhere close. If not then I may have to consider webforms and try to find a maintainable method for these. I've been working in the background on a method of importing excel worksheets into php. Not a trivial exercise but I think it is probably feasible with only minor limitations.
the end solution needs to be compatible with excel 2010 and later.
not looking to create a workbook at all. what i am looking to do is find an ironclad, totally secure, method of providing highly sensitive data to workbooks for staff to use but not see (the raw data), copy, change etc etc.
and it needs to be maintainable.
i appreciate that MS tools are not the best for this. I'm trying to work out whether I can get anywhere close. If not then I may have to consider webforms and try to find a maintainable method for these. I've been working in the background on a method of importing excel worksheets into php. Not a trivial exercise but I think it is probably feasible with only minor limitations.
Could you provide a little more information of what are you trying to accomplish? Not ‘how to do it’ but ‘what would be the best way to…’
Are you trying to ‘grab’ the data from (some kind of) data base and present it to the user as a report? If so, you can create an Excel Workbook with the data of your choice, save it as PDF, and get rid of Excel.
Would that qualify as "an ironclad, totally secure, method of providing highly sensitive data [...] for staff to use but not see (the raw data) "?
Have fun.
---- Andy
A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
Are you trying to ‘grab’ the data from (some kind of) data base and present it to the user as a report? If so, you can create an Excel Workbook with the data of your choice, save it as PDF, and get rid of Excel.
Would that qualify as "an ironclad, totally secure, method of providing highly sensitive data [...] for staff to use but not see (the raw data) "?
Have fun.
---- Andy
A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
- Thread starter
- #5
sure.
this is for a big company. one of the largest in the uk.
it has disparate product lines. this is for one in particular; but the concept should be portable.
we create pricing tools which allow sales to enter basic information about customer needs and out comes a quote.
although the input is relatively anodyne, the data needed to create the quote from the input is highly complex and extremely sensitive (in a competitive sense).
so i'm trying to find a way to allow a workbook to be circulated around the business without being worried that an employee might inadvertently send the workbook out to his personal account or to a customer in error.
we rely in most product lines on excel protections and passwords plus employee contractual controls. but the data involved in this worksheet is an order of magnitude more sensitive.
The business does not use IRM. there is no prospect of rolling that out across the user base.
does that help contextualise?
this is for a big company. one of the largest in the uk.
it has disparate product lines. this is for one in particular; but the concept should be portable.
we create pricing tools which allow sales to enter basic information about customer needs and out comes a quote.
although the input is relatively anodyne, the data needed to create the quote from the input is highly complex and extremely sensitive (in a competitive sense).
so i'm trying to find a way to allow a workbook to be circulated around the business without being worried that an employee might inadvertently send the workbook out to his personal account or to a customer in error.
we rely in most product lines on excel protections and passwords plus employee contractual controls. but the data involved in this worksheet is an order of magnitude more sensitive.
The business does not use IRM. there is no prospect of rolling that out across the user base.
does that help contextualise?
SkipVought
Programmer
Hi,
Hire a programmer to deliver a secure application.
Otherwise Excel is not your secure platform! Never was and more than likely never will be!
Hire a programmer to deliver a secure application.
Otherwise Excel is not your secure platform! Never was and more than likely never will be!
- Thread starter
- #7
SkipVought
Programmer
...Just don't believe that an add-in can fix a sieve.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question