Forum Discussion
Linking Workbooks Automatically & Macro To Share With Clients
mathetes Thank you for getting back to me. Before I get into your response I'll say this.
I have realized that I cannot use the workbook share solution because I need to have the workbooks open at the same time while the information is being modified in order to see those changes.
My hope was that I didn't need to open the Client Workbook and that I would only need to handle data through the Master Workbook. Needing them both open negates the purpose.
To hit on your reply;
the goal was based around my bosses needs and preferences. They did not want a PDF image being sent out. They wanted a single share option where the client would receive the share link, then they could always access their information and we could just send reminders to check the summary as it is updated weekly. Basically they want as simple an update process as possible.
My Master Workbook has nothing in it as we were looking for solutions prior to filling any information out. The most I have is a table template that we can fill in per client per tab.
At this point because my bosses aren't keen on my workarounds or other solutions, I'm essentially back at square one.
I do appreciate the help though.
FWIW, having worked for bosses, and having been one too, I think it's often appropriate to respectfully challenge their preconceived notions, especially if (instead of calling it a "workaround") you speak of, say, distributing a PDF as an alternative and actually easier way to send out those weekly updates. Point out you'd be meeting the goal of communicating with, and updating, the client. That is, this IS the simple update process.
FWIW, at one point in my career (I retired a long time ago), I was in charge of the HR and Payroll database of a major corporation. There were occasions when I still had to challenge higher level execs who had preconceived notions of reports they "needed"--my goal (when those occasions arose) was always to show that there was a better way to accomplish the very thing they wanted to do. Not everybody likes to be questioned; I certainly realize that, so you do have to pick the right time, but make it a matter of saying yes to the goal, not just "No" to their way.