When clicked it will open “select file” box already pointing to the file that was referenced. On this toolbar there is a button that has a red exclamation mark. Once you have your workbook and worksheet formatted the way you want them. "Import external data" may continue to be your solution. Possible solution, and other users correct me if I’m wrong. #Excel text import wizard not prompting updateRe: Update worksheet from Master workbook I do not know anything about VB, but I'm willing to learn. Each file is hundreds of rows and maybe 15-20 columns, so the thought of linking each cell is more than I'm looking to do. The databases are highly sensitive information so I can't really attach one - but I will attach a dummy example of what they all look like. Surely Excel has an easier way to do this? Therefore, I have to delete and re-import every morning, losing all of my formatting. Right now I'm relying on import external data, but that doesn't update. I'd like for these sheets to automatically update if/when changes are made to the master - but keep my formatting intact. I've made a workbook with 7 different sheets, each tab named after one of the network databases. I've tried doing the share workbook, but it's not working. I rarely have to edit, so if I'm first then I'll invariably be asked to exit so others can update them. The first person to open a file will get edit mode, the others will only get read-only mode. Any changes that need to be made are made. These are contact databases for clients, insurance companies, our agents, etc. There are 7 files on the network that everyone updates. I thought I was intermediate, even advanced, until I started coming here! Unfortunately, I'm basically an Excel Dummy. I've searched through the forums here, and some of the answers come close, others assume I know the prerequisite's.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |