Share via

Macros with Data Model

Anonymous
2023-03-13T00:39:53+00:00

I set up a spreadsheet with a Data Model and a Power Pivot coming from that model. I was trying to use Macros to sort my results on multiple columns before publishing the results. When i set up a block and tried to Assing A Macro, none of my macros show up in the list of available macros. Why should this occur and how can I fix it?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-03-13T03:32:51+00:00

    Check your macro code. It should be in general here.

    If your code is workbook or worksheet here, it can't be assigned to a button.

    You can also share your workbook (OneDrive or Dropbox etc.) with code to us to check on it.

    0 comments No comments