Analysis Toolpak on Excel issues on Mac

I recently used Analysis Toolpak on Excel for Mac. I ran a "rank and percentile" analysis on data, and it hung for some reason. I had to force quit excel.

When I restarted excel, I noticed that some issues started to occur, including:

• The default paste function (Command-V) was only pasting unformatted text only. Weirdly enough Ctrl-V worked perfectly fine. Also, paste special > all works fine as well.
• Pressing return on a cell did not move down to next cell. By default, it was like pressing F2 instead.

I turned off the analysis toolpak. The cell return issue disappeared, but command-v was still only pasting values. I tried reinstalling excel to no avail.

Anybody have any suggestions on how to get my default paste function back to normal?