Linked Path Character Limitation

[Kevin S]

I'm having all kinds of issues linking to an external spreadsheet which has a huge cell reference formula in Excel 2013. The formula exceeds the character limitation. Here is the current formula,
='\\pvmx6180\wfm\CC_Staffing_&_Training_Model\Staffing_Models\[Judi.xlsb]Farmington_Accent'!$CW$293+'\\pvmx6180\wfm\CC_Staffing_&_Training_Model\Staffing_Models\[Judi.xlsb]Farmington_Accent'!$CW$347+'\\pvmx6180\wfm\CC_Staffing_&_Training_Model\Staffing_Models\[Judi.xlsb]Farmington_Accent'!$CW$350

I can't map to a network drive as this is accessed from individuals throughout my company. I've tried using the HYPERLINK formula, but I can only get to the point where it opens the workbook. This is what I have so far, =HYPERLINK(AAQ463&AAQ547), where AAQ463 = '\\pvmx6180\wfm\CC_Staffing_&_Training_Model\Staffing_Models and AAQ547 = Judi.xlsb.

Any help will be greatly appreciated.

Kevin

 

[NARAYANK991]

Hi Kevin ,

I am not able to understand what issues you are facing with the formula you have posted ; what limits is the formula exceeding ?

Can you upload a sample workbook with the problem formula ?

Narayan

 

[Kevin S]

Narayan,

Attached is an example of the file I used. I've reduced the size to make it easier to send. Cell E11 has the formula mentioned above.

\\pvmx6180\wfm =network folder
CC_Staffing_&_Training_Model\Staffing_Models\ = folders on the network folder
Judi.xlsb = workbook
Farmington_Accent = worksheet
CW$350 = cell in worksheet

I want t avoid having to map a network drive letter.

 

[NARAYANK991]

Hi Kevin ,

Thank you for uploading your file ; I am still in the dark about the issues you are facing with this formula. Can you please explain ?

Otherwise you can wait ; someone else who has understood your problem will help out.

Narayan

 

[Nebu]

Hi:
As per my understanding you are doing 3D referencing, one solution for this problem is to move the sheets from workbook Judi to your workbook....