linking

What I am trying to do is have an Excel 2003 spreadsheet (A) where data gets entered, and a summary Excel spreadsheet (B) where I have graphs set up to take the linked data from A and graph it. All of this so that a supervisor can log onto the company network and open spreadsheet B and see...

Hi All, I need a bit of help. I have a report where i want to filter 2 pivot tables from one selection. I found a bit of code on the internet which allows me to do it, but just realised that it doesn't work when "Select Multiple Items" is selected in the pivot selection. This is the code i'm...

Hello, I am creating a userform for employees to request office supplies. Their requests creates one database so we can see how many supplies are being used, and which departments have the greatest needs. I have another database of the supply inventory that I would like to be instantly...

Hi, I have two seperate .pptx files. Each of the files has an exact copy of the same powerpoint slide. Is it possible to link a sheet in file as a copy of the same sheet in another powerpoint file?

Hello Everyone!!! Is their a possible way to link exported XL data to a website & then import updated changes on the same webpage back to XL??? :confused::confused::confused:

Hello, I have spent some time googling and searching in this forum for this answer, and I am sure it exists somewhere, but I am not clear on it, so I apologize in advance if this is a newbie question. I have a folder in Dropbox (important that it is stored there, it is shared with 15 people...

Hello, I have searched through this forum extensively and have attempted various combinations of solutions to problems that are similar to mine, but not quite exactly. Although mentally exhausted I am not giving up quite yet. My task is seemingly quite simple: Have part numbers in a...

I have some hyperlinks in Excel documents which link to Shortcuts of files I created in a different folder. Some of them are not working any longer...Excel just spins when I click on them. Any ideas?

Hello Friends Is it possible to allow linking to a password protected Access database? I am maintaining a database in Access 2007 that I want to protect by a password so that nobody can change tables etc. At the same time I want other users to be able to link to those tables without giving out...

While running a report (one which has several groups, and several subreports) I get one parameter I expect ("Enter ID number you wish to report on") as well as a parameter I did not expect to see. It just says "Catalogue". Which is the name of a table which the main report is based on and the...

Struggling to create an externship work schedule for approximately 12 students. Three separate companies are offering the students Monday through Saturday hours, each company has multiple locations (up to 8) and varying times slots over a 12 week period. Need to list all available dates and...

We have a transaction log which I would like to populate from the data of individual sheets, i.e. requisitions. As the sheets will be clones of each other certain data, i.e. requisition numbers would be diffrent (an individual indentifier) but would be located in the same cell on each sheet. So...

Hi folks-- Just wondering if there is any way that I can use data from an Access table in my Excel functions without importing the Access data into the wookbook. I set up a connection to the Access table that I need, but don't know what the syntax would be to reference those fields in...

On my PC I have no problem starting Excel, opening two files that are linked and seeing the destination file change instantly when I update the source file. However, if instead I start two Excel applications and open only one file in each the link does not work. For instance If I add a test...

hi all, I want to know how to have a numerical value of a cell but with the cell text being a word, how do i do it in excel '07? I want it so when i look at the cell i can see when the cell is(text) but when i multiply it by another cell the figure will be used?

Hi, I have a problem with Excel 2003. If I make linking between another worksheets in a workbook or when I try to link from other worksheets in formula does application excel.exe to crash. see sample ( formula in cell =+'D:\Document_2009\FII_Financ\2009\PDC\[calculation_pdc_2009.xls]Oct'!$BW$8)...

Hi, When you are linking two spreadsheets together, is it possible to carry over the conditional formatting from one spreadsheet to another? I type in = and click in a cell with conditional formatting on Spreadsheet 1 I want the conditional formatting in the Spreadsheet 1 to carry over to...

Hello, I have been frustrated by this problem for some time- Whenever I try to update the source for data links in 2007 (Data>Connections>Edit Links>Change Source) excel ALWAYS freezes! I've tried this on other machines as well and the same thing happens... useful info: -I am trying to change...

Is there an easy way to change all of the links in a Word document? Let's say, I have a linked word document and an excel workbook that I set up as templates to use. I'll be entering data into tables in excel, and those tables are linked to the word document. Each time I start a new project...

I have two option buttons on a userform. One says yes and one says no. There are two command buttons (back and next). If the user selects yes and then clicks the next button, I want it to go to userform2. However, if the user selects NO and then clicks the Next button, I want it to got to...