Skip to content

Rose Add-in for Excel FAQs

Q: Where was my Rose add-in installed on my computer?

A: By default the add-in files will be located in this directory:

c:\users\<myname>\appdata\roaming\microsoft\addins\

Q: I just ran the Rose desktop app installer and now when I try to push and pull I get this error:

Traceback (most recent call last):
  File ""<string>"", line 1, in <module>
  File ""c:\users\myname\appdata\roaming\microsoft\addins\addin2.py"",
line 3, in <module>
   import xlwings as xw
 ModuleNotFoundError: No module named 'xlwings'

A: The required packages for the add-in were not installed correctly. Follow these steps to resolve this issue:

  1. Close all open excel windows
  2. Open up a windows terminal window from the start menu by searching Command Prompt
  3. With the command prompt window open enter the following commands:
    1. pip install pywin32 anytree
    2. pip install xlwings==0.10.4 yfinance fredapi
    3. python -m pip install --index-url=https://bcms.bloomberg.com/pip/simple blpapi
    4. pip install rose_wrapper --extra-index-url https://1In9Zq-2vdZIr79rhx99dBfUjwStGiiS3Y@pypi.fury.io/rosetechnology --upgrade --no-cache-dir
  4. Open excel and try to pull usa.lr and a code owned by you or your company.

Q: How do I change my rose account on my excel add-in?

A: Follow these steps in order to change your rose.ai login associate with your Rose add-in for Excel

  1. Use the =login(username, password) function to switch accounts. Replace your username and password with your credentials.
  2. Alternatively, you can use the email associated with your Rose account instead of your username.

Q: My add-in wasn’t activated or I keep getting NAME? Error in excel

A: The add-in wasn’t activated.

To fix this do the following:

  1. Open the Trusted Locations menu. File> Options> Trust Center> Trust Center Settings> Trusted Locations
  2. Press the Add new location… button.
  3. Click the Browse… button.
  4. Navigate to the folder that contains your add-in files and press OK.
  5. Press OK, then press OK again on the Trust Center Window.
  6. Close and re-open Excel

Q: Error message: “Sorry, we couldn’t find add-in [add-in name]. Is it possible it was moved, renamed or deleted?”

A: This could happen after you delete an Excel Add-in file without uncheck it from the Excel Add-in dialog box.

That's because the Add-in isn't properly unloaded before the Add-in is deleted, so Excel tried to load it every time a new workbook is opened but can't find it.

How to Fix:

  1. Open a new blank Excel file
  2. Save the file with the following conditions:
    1. Use Excel file extension “.xlam”
    2. Save the file with the same add-in name in the error message
    3. Save it under the same folder as the folder stated in the error message
  3. Once you have saved this new faux add-in file, close down Excel
  4. Open Excel, go into your Excel Add-ins dialog box and check the add-in and hit Ok
  5. Go back into you Excel Add-ins dialog box and uncheck the add-in and hit OK
  6. Close out of Excel
  7. Delete the faux Excel add-in file