Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying links without updating values..
I have a workbook which works exactly as I wish. This workbook pulls data for
a month via links to the production data workbooks, the one I have built is for the month of may. I want to replicate it for each month. If I do a find and replace for the word may, I will get propmted to update the values for each cell containing may, I have over 24,000 cells with may in them. It will still do the replace, even though the June files dont exist yet, by hitting cancel. How can I get excel to change these links without prompting me to update values for every single cell? I can take once per worksheet but 24,000 for one workbook is a bit too many times to have to hit cancel... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying links without updating values..
I think I'd wait for the next month's file to be created or create a dummy
workbook that makes the links work (not return the correct values--but at least not do what you describe). GOHOINC wrote: I have a workbook which works exactly as I wish. This workbook pulls data for a month via links to the production data workbooks, the one I have built is for the month of may. I want to replicate it for each month. If I do a find and replace for the word may, I will get propmted to update the values for each cell containing may, I have over 24,000 cells with may in them. It will still do the replace, even though the June files dont exist yet, by hitting cancel. How can I get excel to change these links without prompting me to update values for every single cell? I can take once per worksheet but 24,000 for one workbook is a bit too many times to have to hit cancel... -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying links without updating values..
I found that if I right click on the sheet tabs and "select all sheets" it
only asks me once per sheet for each of the different files it is calling (3 different files per sheet in this case so 3 clicks per sheet now instead of over 2,000 per sheet and 24,000 per workbook) but thanks for your response... "Dave Peterson" wrote: I think I'd wait for the next month's file to be created or create a dummy workbook that makes the links work (not return the correct values--but at least not do what you describe). GOHOINC wrote: I have a workbook which works exactly as I wish. This workbook pulls data for a month via links to the production data workbooks, the one I have built is for the month of may. I want to replicate it for each month. If I do a find and replace for the word may, I will get propmted to update the values for each cell containing may, I have over 24,000 cells with may in them. It will still do the replace, even though the June files dont exist yet, by hitting cancel. How can I get excel to change these links without prompting me to update values for every single cell? I can take once per worksheet but 24,000 for one workbook is a bit too many times to have to hit cancel... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating External Links | Excel Discussion (Misc queries) | |||
Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Excel 2003 links are not updating between workbooks | Excel Worksheet Functions | |||
External Links not updating | Excel Discussion (Misc queries) |