shared excel

Hi everyone, I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet. Current...

Hello, I would share an excel file with some people and I would like that each time an user who will open the file a new worksheet will be created. This new worksheet will be based on an template and named with the microsof account of the user. If the same user will open again the file, He has...

Hi, I have the following piece of code running when opening a workbook. I want this workbook to be shared, but when I open in shared mode this piece of code gives me a run-time error '1004': Application-defined or object-defined error. Works fine when not in shared mode. I have googled...

Hi guys, Hoping forsome guidance on how I can achieve a log of activity to be automatically generatedwithin a shared workbook. Currently I have a functioning code for a single userbut I don’t think it can work for multiple users looking at the workbook at thesame time. Presently,the below...

Hi everyone, Hope all is well. I have a database where atleastt 5 users work simultenously on a shared worksheet. How can we fix issues (not responding, missing entries, data corruption, hang up) being faced by multi-users while updating an excel file? On an average, there are six to seven...

Hello guys, can you please help me with the below issue I am facing. We have got an excel file saved in network server and shared for editing by multiple users. Generally it works fine but sometime when trying to save after doing some edits it says the file is read only and to save changes save...

i am looking for some advice, and my assumption is that this is likely to need VBA... I currently run a shared file with VBA that will send me an email stating that changes have been made to said file. This is only useful, however, if the end user is has Microsoft Outlook running on their...

I have a workbook that I have set to be shared by multiple users on different computers but all on the same network. How do I change the settings so that the workbook saves changes automatically without any popup message?

I am completely new to VBA, but from what I know it seems this should be possible. Could anyone please walk me through how (and where) to enter a VBA that will automatically save the shared workbook any time any user changes any cell. The practical application is that I have a PO log that...

You kind folk from MrExcel helped me to design a brilliant Order Number Sheet which between 3 users we can tick each O/N off using macros. This has helped us greatly. However the file is currently on a shared googledrive - the only problem is that we can all access the file at the same time and...

Hell all, This is my very first post here. I have a beginner's experience in Excel and I have encountered an issue that I wasn't able to find a solution for online. I am using a shared excel file that is a data entry form shared by 12 users. Each person gets in, fills information and hits a...