share

Hello everyone, I've built a report (several Pivot Tables with Slicers) which loads data from various sources through Power Query and has various fields/relationships added in Power Pivot. One of these relationships allows me to filter for performance by Manager. I would like to share this...

Hey everyone, I have around 80 or so files that are all named something different but located in one folder in a SharePoint folder. I have a master file as well which is also in that same SharePoint folder. I need to pull data from a specific worksheet from each of the 80 files (named Code...

Hello, I created a simple flat DB and posted it on our share drive. It is one table, one form, one report and an export to excel. There is a menu table that has 3 buttons on it, 1 to open the form, 1 for the report and 1 to export.. I have had 4 people attempt to open it, 2 can, 2...

I am trying to share a custom Excel 2010 ribbon tab, but everytime I export and the other user imports, it overides their quick access toolbar as well. Is there any way around this, or do I just need to setup the quick access toolbar again? Thanks!

Hi, I want to share a blank Excel worksheet to multiple users and collect their responses. I looked into SkyDrive and Sharepoint. With my limited knowledge of the two, it seems like all my users would need to have an account to the program and they would be able to see others response, which...

Hello! I am trying to do a simple database for a small, but very busy, company. I have decided to make it in Access after a lot of reading... there's a huge debate out there in the web related to Access and SQL and I would like to avoid any discussion in this post if possible. We currently...

Hi everyone, I am having some problems with locking and protecting my worksheet. I have an excel table with 7 columns. Column 1 has data validation; a dropdown list which references a hidden worksheet with a table of values linked to Access. Column 2 has vlookup formula, which looks up the...

i have an excel template that requires people to make choices using drop down lists. how can i email this template in the message body so that the recipient can then choose from the drop down list and then submit by email. i know i can send them the file as an attachment, but i want to send it...

I have about 10 users on a terminal server running Excel. Office is not installed on the server, just Excel. There is a custom spreadsheet that access various databases that they need to use. I'd like to save the spreadsheet as a template, si I can update, secure, and maintain it in one...

Hi! I need a macro to check if .xlsx files in a specific directory are shared, as we have need them always shared, but the users forget them to share after some editing. It will be very cool of the macro could make the unshared files shared, but this should be hard work. The most important...

Hi, Using VBA I need to be able to update a workbook whilst other users are using the file, As the file contains Pivots I cant simply share the file (using XL 2003 - upgrading is not an option). I thought I could lock the sheet down by making it read only password protected however the code...

Hi, I'm using a random number generator in excel to create values between 17.0 and 21.0 to one decimal point. Currently using =RANDBETWEEN(1700,2100)/100 to achieve this. (It will give me 18.3 / 19.4 etc etc). I'm then using this to create 100 random numbers between 17 and 21. What I want to...

I have searched for about an hour in the threads looking for an answer to this, and have had no luck. We are a small group spread out all over the world trying to work on some excel sheets. The master workbook has links to other workbooks. Is there a way to force all of the links to only...

Dependent Variable: Date Changing Variables: Values in two different columns I'm calculating return for a stock (-5, 5), (-2, 2) and (-1, 1) days from the date of announcement of a deal and doing the same for a market index. As you would have figured by now, the date of announcement...

Here is my sample data. I want the sales rep can only see their own records and update the status in the third column. I tried the workbook share option. It seems that all sales reps can access the workbook at the same time but also see other's record. Any sugguestion? <TABLE...

I have WKBK #1...and I want to create WKBK (#2) which will always pull info from WKBK #1. In addition to that, I want to be able to edit WKBK #2 and add info w/o affecting WKBK #1. Creating a 'backup file' and adding info to the 'backup' does not work... HELP!! HELP!! HELP!! HELP!! HELP...