Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Validation
Win XP; Office 2003
Paste formula from linked files. This is the command I'm using: on the destination file; highlighted the cell with the formula -- click on the copy icon -- place cursor on upper left of cell, then drag to the other cell locations -- select the down arrow next to the paste icon -- paste special, select the formula and transpose boxes. This works great! It increments the formula ie. C1 to C2 etc. and the value of the source file is shown. However, when forwarding the files to someone else; she has the validation tool come up and needs to browse to the source file. How can I remove that? I have not protected the sheet... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special Problem | Excel Discussion (Misc queries) | |||
strange Paste special | Excel Discussion (Misc queries) | |||
paste special - formulas | Excel Worksheet Functions | |||
In Excel: Paste Special should have a "Link Value" Selection | Excel Worksheet Functions | |||
Paste Special Question | Excel Discussion (Misc queries) |