sharing

Hi, This is my first post- please forgive/inform me of any mistakes. I am trying to automate a repetitive reporting process. Before I can upload my reports, I have to protect a sheet, protect the workbook, and "Protect Shared Workbook." This last step brings up a box where I check "Sharing...

I just recorded a macro that I saved to my Personal Macro Workbook on my mac computer with Excel for Mac 2011. I want to share this with my co-worker who has a PC with Excel 2007. I saved the file with the macro recording saved as an .xlsm and then e-mailed it to him, but we couldn't figure out...

I am exporting query results from Access into Excel and need to "Share" the document so multiple users can update at once. Currently I am exporting and then going into each individual document and sharing the workbooks manually.</SPAN>

We have an Excel file stored on a network server that is accessed by multiple users throughout the day. Typically, if one user has the file open in read/write, any other user attempting to open it in read/write will get the " currently in use" prompt. However, just recently one particular user...

Hi, I've been looking on an answer of how to do this, and most of what I've found regards what I CAN'T do, vice what I CAN. Problem: I have multiple users that need to edit an excel file simultaneously, I'm want to maintain one copy instead of sending everyone an email with the document to...

I have a standard table full of numbers, bottom row has adding formula (example) =H4+D4+B4 . Is there anyway to have characters in the same cell as the numbers without the cells that show totals displaying #VALUE! Seems cells can only contain the digits, no letters Thanks for any help

I have large spreadsheet that I use to bid on construction projects that I need to have 10 to 12 users in simultaneously sharing the spreadsheet and entering numbers, running macros, sorting, filtering, adding rows, etc..... We tried this in Excel on our local area network and had lots of...

A question has been posed to me that is a little beyond my scope of familiarity. A coworker was wondering if it would be possible to have a sort of constantly-update-add-in for all the networked computers in the office, so that all of the users could have access to his macros, and wouldn't have...

I am having trouble sharing an Excel Add-in I've created which contains three macros (modules). I have looked everywhere but, oddly, I can't seem to find a definitive answer. I would like for people to be able to install the add-in, and have access to three macros which it contains. What is...

Hello :) I have a few questions, I'm hoping someone can help. I have two workbooks, one (the master workbook) contains a several databases, the other (general workbook) contains worksheets designed to look up information in and add information to the databases using macros. Data is copied...

Hi all, I need some suggestion, to solved my problem..i have one pc server (assume pc as server) and will connect to 3 others pc..connect here mean,3 others pc will take the data from pc server and was allowed to edit that data.. That 3 others pc also will connect to each other.. in a meantime...