How to protect financial data while sharing an Excel spreadsheet with a consultant?automatically transfer any...

What to do when during a meeting client people start to fight (even physically) with each others?

How does Dispel Magic work against Stoneskin?

what does the apostrophe mean in this notation?

Co-worker team leader wants to inject the crap software product of his friends into our development. What should I say to our common boss?

Are there situations where a child is permitted to refer to their parent by their first name?

What is the definition of "Natural Selection"?

Does the Bracer of Flying Daggers benefit from the Dueling Fighting style?

Excess Zinc in garden soil

Can someone explain this Mudra, done by Ramakrishna Paramhansa in Samadhi?

My story is written in English, but is set in my home country. What language should I use for the dialogue?

Playing ONE triplet (not three)

Format picture and text with TikZ and minipage

Is it ok to include an epilogue dedicated to colleagues who passed away in the end of the manuscript?

Who is our nearest neighbor

Potentiometer like component

Should QA ask requirements to developers?

Can the druid cantrip Thorn Whip really defeat a water weird this easily?

Giving Plot options defined outside of the Plot expression

Rejected in 4th interview round citing insufficient years of experience

What has been your most complicated TikZ drawing?

What wound would be of little consequence to a biped but terrible for a quadruped?

Is having access to past exams cheating and, if yes, could it be proven just by a good grade?

When is a batch class instantiated when you schedule it?

How do anti-virus programs start at Windows boot?



How to protect financial data while sharing an Excel spreadsheet with a consultant?


automatically transfer any data on excel spreadsheet to master spreadsheetexcel spreadsheet average with prioritizationExcel pivot table field grouping problems (numbers seen as text)In a table of groups and members, how to reduce a certain percentage of members per group?Excel Spreadsheet data movementExcel Formula using IF and OFFSET in Attendance TrackerHow do I set up a conditional formula with multiple criteria?Excel spreadsheetHow to find correct column to use in one worksheet for formula in anotherCreating Excel Financial model













0















I have an excel spreadsheet i'd like to share with a consultant, which contains proprietary data, but I wonder if there is a way to mask number or randomize it somehow with a key that would revert it back whenever needed, but still keep the formulas and logic intact so it can be reviewed with consulting group.



Thanks in advance.









share







New contributor




Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I have an excel spreadsheet i'd like to share with a consultant, which contains proprietary data, but I wonder if there is a way to mask number or randomize it somehow with a key that would revert it back whenever needed, but still keep the formulas and logic intact so it can be reviewed with consulting group.



    Thanks in advance.









    share







    New contributor




    Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I have an excel spreadsheet i'd like to share with a consultant, which contains proprietary data, but I wonder if there is a way to mask number or randomize it somehow with a key that would revert it back whenever needed, but still keep the formulas and logic intact so it can be reviewed with consulting group.



      Thanks in advance.









      share







      New contributor




      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I have an excel spreadsheet i'd like to share with a consultant, which contains proprietary data, but I wonder if there is a way to mask number or randomize it somehow with a key that would revert it back whenever needed, but still keep the formulas and logic intact so it can be reviewed with consulting group.



      Thanks in advance.







      microsoft-excel worksheet-function privacy ms-security-essentials privacy-protection





      share







      New contributor




      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 42 secs ago









      Elliot AndertonElliot Anderton

      1




      1




      New contributor




      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Elliot Anderton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Elliot Anderton is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1413846%2fhow-to-protect-financial-data-while-sharing-an-excel-spreadsheet-with-a-consulta%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Elliot Anderton is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Elliot Anderton is a new contributor. Be nice, and check out our Code of Conduct.













          Elliot Anderton is a new contributor. Be nice, and check out our Code of Conduct.












          Elliot Anderton is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1413846%2fhow-to-protect-financial-data-while-sharing-an-excel-spreadsheet-with-a-consulta%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Cannot install PyQt5 The Next CEO of Stack OverflowCannot install tcpreplay 3.4.4cannot...

          Kapp-Putsch Acontecimentos | Outros artigos | Menu de navegação

          Why did early computer designers eschew integers? The Next CEO of Stack OverflowWhat register...