Spreadsheet: 249505d1373540089-excel-slow-open-save-i-think-because-of-hyperlinks-hyperlinksolution
Sheet: Sheet1

Hyperlink you already have | Copy pasted as values | creating new hyperlink using formula
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8241 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8241
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8242 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8242
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8243 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8243
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8244 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8244
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8245 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8245
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8246 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8246
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8247 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8247
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8248 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8248
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8249 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8249
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8250 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8250
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8251 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8251
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8252 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8252
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8253 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8253
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8254 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8254
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8255 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8255
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8256 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8256
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8257 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8257
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8258 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8258
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8259 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8259
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8260 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8260
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8261 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8261
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8262 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8262
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8263 | \\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8263
 |  | Once this new hyperlink is created. Remove the old hyperlinks