Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-504

IP allow list prevents Jira Cloud for Excel from connecting

    • Icon: Bug Bug
    • Resolution: Answered
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Excel
    • None
    • Severity 3 - Minor
    • Hide
      Atlassian Update – 04 Apr 2022

      If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:

      34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165
      

      This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.

      Show
      Atlassian Update – 04 Apr 2022 If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list: 34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165 This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.

      Issue Summary

      Setting up an IP allow list prevents Jira Cloud for Excel from connecting to the instance.

      Steps to Reproduce

      1. Set up an IP allow list
      2. Install Jira Cloud for Excel
      3. Authorize Jira Cloud for Excel to use your account
      4. Try using Jira Cloud for Excel 

      Expected Results

      Jira Cloud for Excel should be able to connect to the instance and work normally.

      Actual Results

      Authorization works but Excel does not update (using Autoreport feature)

      Workaround

      If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:

      34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165
      

      This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.

            [API-504] IP allow list prevents Jira Cloud for Excel from connecting

            Vitalii Saienko (Inactive) made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 631873 ]
            Vitalii Saienko (Inactive) made changes -
            Resolution New: Answered [ 9 ]
            Status Original: Gathering Impact [ 12072 ] New: Closed [ 6 ]
            Vitalii Saienko (Inactive) made changes -
            Current Status New: {panel:title=Atlassian Update – 04 Apr 2022|borderStyle=solid|borderColor=#deebff|titleBGColor=#deebff|bgColor=#ffffff}
            If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:
            {code:java}
            34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165
            {code}
            This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.
            {panel}
            Vitalii Saienko (Inactive) made changes -
            Description Original: h3. Issue Summary

            Setting up an IP allow list prevents Jira Cloud for Excel from connecting to the instance.
            h3. Steps to Reproduce
             # Set up an IP allow list
             # Install Jira Cloud for Excel
             # Authorize Jira Cloud for Excel to use your account
             # Try using Jira Cloud for Excel 

            h3. Expected Results

            Jira Cloud for Excel should be able to connect to the instance and work normally.
            h3. Actual Results

            Authorization works but Excel does not update (using Autoreport feature)
            h3. Workaround

            If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:

            {{34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165}}

            This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.
            New: h3. Issue Summary

            Setting up an IP allow list prevents Jira Cloud for Excel from connecting to the instance.
            h3. Steps to Reproduce
             # Set up an IP allow list
             # Install Jira Cloud for Excel
             # Authorize Jira Cloud for Excel to use your account
             # Try using Jira Cloud for Excel 

            h3. Expected Results

            Jira Cloud for Excel should be able to connect to the instance and work normally.
            h3. Actual Results

            Authorization works but Excel does not update (using Autoreport feature)
            h3. Workaround

            If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:


            {code}
            34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165
            {code}


            This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.
            Vitalii Saienko (Inactive) made changes -
            Description Original: h3. Issue Summary

            Setting up an IP allow list prevents Jira Cloud for Excel from connecting to the instance.
            h3. Steps to Reproduce
             # Set up an IP allow list
             # Install Jira Cloud for Excel
             # Authorize Jira Cloud for Excel to use your account
             # Try using Jira Cloud for Excel 

            h3. Expected Results

            Jira Cloud for Excel should be able to connect to the instance and work normally.
            h3. Actual Results

            Authorization works but Excel does not update (using Autoreport feature)

            h3. Workaround

            Please contact [Atlassian support|https://support.atlassian.com/contact/#/] referencing this bug report so we can apply a workaround to fix this.
            New: h3. Issue Summary

            Setting up an IP allow list prevents Jira Cloud for Excel from connecting to the instance.
            h3. Steps to Reproduce
             # Set up an IP allow list
             # Install Jira Cloud for Excel
             # Authorize Jira Cloud for Excel to use your account
             # Try using Jira Cloud for Excel 

            h3. Expected Results

            Jira Cloud for Excel should be able to connect to the instance and work normally.
            h3. Actual Results

            Authorization works but Excel does not update (using Autoreport feature)
            h3. Workaround

            If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list:

            {{34.86.33.169, 34.86.254.214, 34.86.159.247, 35.188.250.227, 34.86.95.48, 34.86.125.23, 34.86.25.26, 34.86.189.204, 34.86.118.203, 34.86.202.157, 34.86.8.82, 34.86.247.165}}

            This applies to Jira for Google Sheets, Jira for Excel, and the export to Google Sheets/Excel from Jira.
            Vitalii Saienko (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            Vitalii Saienko (Inactive) made changes -
            Link New: This issue is caused by API-291 [ API-291 ]
            Daniel Davies made changes -
            Link New: This issue is related to API-291 [ API-291 ]
            Daniel Davies created issue -

              Unassigned Unassigned
              209021ae12e2 Daniel Davies
              Affected customers:
              1 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: