02-04-2020 06:58 AM
02-04-2020 06:58 AM
I came up with a "form" in Excel where my manager will need to complete fields and those fields will populate to an assessment created in Excel. I want the form to be in its own tab so all she needs to do to access the form is click the tab titled, let's call it, "Member Information Entry". I am able to create the form...I am able to see that tab created...however, when I save and close the file, then the next day I open the file, the tab I created for the form is no longer there. How do I get Excel to populate this new tab each time this specific file is opened? I want this to work as seamlessly for her where all she needs to do is open the Excel File, gather her information, input the information, then save. To help save her time, is my ultimate role and for me to teach her how to create this tab each time she opens the file, not only is tedious and unnecessary, it also defeats the purpose of making her job easier...it makes it more complicated for a simple task. I appreciate any help any of you can lend.
02-04-2020 07:59 AM
@PascalKTeam Thank you for your response. No, the file is not a shared file. It is a document I am creating in Excel for my manager to do an assessment on the work performed by her subordinate branch managers. I am the author of the form, and she will be the user. I am in the beginning stages of development of the document. I am working on a computer that is what they called a "virtual station" though.
02-04-2020 08:00 AM
02-04-2020 08:08 AM
@PascalKTeam sure. It is attached. Please keep in mind that yesterday when I built the "form" in the "table" function, I did establish a new Tab in the Ribbon and that tab was there. Then, after saving and closing and going home for the night, when I reopened the file this morning, the tab I established in the Options "Customize Ribbon" menu was no longer there.
02-04-2020 08:15 AM