--- title: "Removed the URL user and URL user password parameters" canonical: "https://support.appfire.com/space/XL/76614287/Removed%20the%20URL%20user%20and%20URL%20user%20password%20parameters" format: markdown --- This page describes the parameters removed, changes, and how the app handles these changes in *Excel for Confluence* - Server and Cloud version. # Parameters removed The *URL user* and *URL user password* parameters are removed from *Excel for Confluence* and are no longer available in the *Excel* macro. > 📝 Parameter removal is effective and available in: > 📝 > 📝 - *Excel for Confluence - *Server (version 7.3.0 and above) > 📝 - *Excel for Confluence* - Cloud # *Excel for Confluence* app updates The *Excel for Confluence *app now uses only *Profile* for the new macro configurations. You can use a *Profile* to access Excel data from a remote location without exposing any sensitive information. > ℹ️ - Upgrade the app and use *Profile* to access the Excel data from external sources without exposing sensitive information such as a password. > ℹ️ - The macro editor does not display the *URL user* and *URL user password* parameters. > ℹ️ - Pre-configured macros using the *URL user* and* URL user password *parameters are supported. The Confluence page retains the values of the *URL user* and *URL user password* parameters in the *[Storage Format](https://confluence.atlassian.com/doc/confluence-storage-format-790796544.html)*. Follow the steps given below to create a *Profile* and configure the *Excel* macro using the *Profile.* **Create a *****Profile***** to access the external sources** Administrators create a *Profile* by defining a set of parameters, such as the base *URL* of the location for the *Excel* data, *User*, *Password*, and other relevant information to access the specified location. For more information, refer to [Create a profile with a URL](https://appfire.atlassian.net/wiki/x/DQaRB). ![image](media://b6de6aaf-c5a4-46da-bdf4-206081bbb398) **Use *****Profile***** to access the Excel data** To configure the *Excel* macro to use *Profile*: 1. Select the *Profile* from the *Profile* drop-down. 2. Enter the relative URL in the *URL to Excel file* parameter. > ℹ️ For more information, refer to: > ℹ️ > ℹ️ - [Excel macro - Server](https://appfire.atlassian.net/wiki/x/lwmRB) > ℹ️ - [Excel macro - Cloud](https://appfire.atlassian.net/wiki/x/RwKRB) ![image](media://2190c8bc-bf44-4937-b19e-601a7f642209) # How the change impacts the pre-configured macro? The removal of parameters does not impact the existing macro configurations or pre-configured macros. Below are the various configuration changes to help you consider and plan the *Excel* macro configuration. - [Retain the pre-configured ](#anchor1)*[Excel](#anchor1)*[ macro](#anchor1) - [Modify the pre-configured ](#anchor2)*[Excel](#anchor2)*[ macro parameter values](#anchor2) - [Copy the pre-configured ](#anchor3)*[Excel](#anchor3)*[ macro](#anchor3) > Macro (anchor) **Retain the pre-configured *****Excel***** macro** - Retain the pre-configured *Excel* macro with the *URL user* and *URL user password* parameters without any change. - Though the macro editor does not display the parameters, the Confluence page still retains the values of the *URL user* and *URL user password* parameters. The app fetches the parameter values from the *Storage Format* to retrieve the data from the remote location. > Macro (anchor) **Modify the pre-configured *****Excel***** macro parameter values** Modify any of the parameter values such as *Page for attachment*, *Name of attachment*, *Name of attachment in the path, Profile, or URL to Excel file *in the pre-configured macro*. *The app considers the updated value of the parameters to fetch the data. > 📝 If the macro configuration contains *Profile*: > 📝 > 📝 - The macro considers the values of the parameters, *User, *and *Password* from the *Profile* for authentication. The app fetches the data based on the chosen *Profile* and relative URL provided in the *URL to Excel file*. > 📝 > 📝 If the macro configuration does not contain *Profile*: > 📝 > 📝 - The macro considers the values of the parameters, *URL user,* and *URL user password* from the *Storage Format* for authentication. The app fetches the data based on the URL provided in the *URL to Excel file*. | | | | --- | --- | | ![image](media://6a5efb51-9f3c-4291-8811-f3814a491284) | ![image](media://adaed1a0-b7a6-4449-8971-34187b54c62b) | > Macro (anchor) **Copy the pre-configured *****Excel***** macro** The behavior of the newly copied macro remains the same as the original pre-configured macro. You can: - copy the pre-configured macro on the same or another Confluence page. - copy the page containing the pre-configured *Excel* macro in the same space or another space. # References - [Excel for Confluence Configuration](https://appfire.atlassian.net/wiki/x/WQqRB) - [Create a profile with a URL](https://appfire.atlassian.net/wiki/x/DQaRB) - [Excel macro](https://appfire.atlassian.net/wiki/x/lwmRB) - [Confluence Storage Format](https://confluence.atlassian.com/doc/confluence-storage-format-790796544.html)