无法解决，这个提示表示用的宏已经遭到破坏或已经不存在了。宏安全性设置成启用所有宏就可以了~你用的什么版本的excel?设置的地方不太一样~
You want to insert an object and Excel shows the message “Cannot insert object”. Solution 1 – Unprotect the Workbook Steps: Go to the Review tab >> click Protect Workbook>> Enter the password >> Click OK. Solution 2 – Change the Macro Security Settings Steps: Go to the Developer tab...
I think these issues may be because of administrative controls on macros. If I have a xlw/py script which opens excel, commands xlw to open a file, and run a macro, it gets blocked. However, if I (1) start Excel from the command line (I'm in a bat script on Windows) (2) op...
Read More: [Fixed] Excel Pivot Table Not Grouping Dates by Month Solution 2 – Filtering to Find Distorted Date Values and Group Dates in Pivot Tables Step 1: Select all the cells in the data range. Click Filter in Data. Click the small downward arrow on the right side of Ship Date: ...
When I assign a button to this Zip macro it gives me this error... But look the code is in the file name...how is it not in there or how can it not locate it and run it through this macro? Can someone please help me with this or offer suggestions? I tried ch...
MS Excel has been inducted in scientific, engineering, statistical, and all financial workplaces. Excel files are the raw data containers that provide input to macro programming facility using Visual Basic for Applications. However, what happened if you meet an Excel file error like "cannot a...
Solution 1: Restart the Excel File Solution 2: Check the Merge Cell Solution 3: Disable the Macro Express Application Solution 4: Use Paste Special Option Solution 5: Ignore DDE Solution 6: Restart the PC in Clean Boot State Solution 7: Start Excel in Safe Mode ...
I have a Macro-Enabled Workbook that I've been using for over a year with no issues in using the macros inside. Yesterday I copied this workbook into my OneDrive folder. Now, when I open the file...Show More excel Macros and VBA office 365 Like 3 Reply ...
When I export a report such as the Balance Sheet to Excel in Quickbooks Desktop Pro 2017, I save the file as an XLSX. However, Excel warns me: "The following features cannot be saved in macro-free workbooks: -Excel 4.0 function stored in defined names"...
Select Disable Macro from the context menu when you right-click on the macro. Method 4. Use Paste Special Option to Fix the Error When utilizing the "Paste" option in Microsoft Excel, the data cannot be pasted due to an error. Step 1. Make a copy of the relevant data from the Excel...