excel links

  1. D

    Excel links to other sheets not working after converting to PDF.

    Hi, I've got a spreadsheet that I use as a dashboard and we have navigation links to the various sheets that are hidden from the users and when converting the dashboard to PDF, the internal links don't work. Any thoughts on options for this?
  2. S

    Excel linked to another file when opened after created by macro

    Hi, I created a macro that copies a new tab into a new file and completes this new file from the one that it comes and after it finishes it saves this file. When this is over, I check the file and it is not linked, but when I close it and open it again it is linked to the source file (the one...
  3. B

    Excel links "THIS WORKBOOK ONLY!" for excel template

    Hi All! I am creating a boiler plate template workbook in Excel that I using many many copies of. I want to save as a template and reuse instead of "saving as" each time. I have many formulas and macros within the sheet. How can I write the formulas and macros to specify "this workbook only"...
  4. B

    SIMPLE ISSUE with dragging a reference

    I need I drag a simple cell reference through a series of rows AND columns for example... In cell a1 =m1 b1 =m2 c1=m3 A2 =m4 b2 =m5 c2=m6 When I drag it it obviously drags incorrectly. I also tried making m absolute but it still did not drag correctly. I just really don't want to...
  5. T

    Keep workbooks linked when the path changes XL2003

    I have two workbooks. Workbook A contains four spreadsheets (of various customer data). Workbook B uses formulas and queries to import the data from Workbook A. I have to email, or upload both of these workbooks to a customer so they can continue to update the data in Workbook A, and...
  6. M

    Create a link between two Excel files

    Hi there, I am trying to create a link between two excel files on an FTP Site but I can not find a working result. What I have: A folder x:\general costs Inside this folder there is a file called costs1.xls which has 3 sheets (Sheet 1, Sheet 2, Sheet 3) Sheet 1 has for example 4 cells (A1...
  7. L

    Linking to 200 worksheets

    I had an unusual question come to me at work. A manager is creating a report by linking one summary spreadsheet in the same workbook as 200 other spreadsheets where those who report to him enter data into various tables. He wants to know if there is a way to navigate the workbook more easily...
  8. S

    Can't fully copy links with dashes in them

    With some of my data processing tasks, I'm given an Excel file with many links in column A, and then copy and paste them into a browser. For links that do not have dashes in them, I can just click the link once and it will auto-highlight, allowing me to then just Ctrl + C and move on with...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top