Tag Archives: excel

Excel pivot table data source not valid

The perspective is needed because the work requires it, and it turns out that no matter how you create it, it always says “data source invalid”
Checked Baidu experience, after saying is two reasons: 1. Title bar has space 2. Title bar may be merged cells
But it is of no damn use
In the deletion of no sequence is still invalid after finally found the reason, the original is the reason for the file name, the file name can not have [], tragedy, thank you here this netizen, in order to forget, or write an article to commemorate it
The original link:
https://zhidao.baidu.com/question/367555675.html
 

VBA returns “n / a” and other error information

When we use Excel’s built-in functions to return A Value, if the argument is wrong or cannot be found, we often return #N/A or #Value! And so on prompt message.
Can the VBA code we write in the module also return this information?
The answer is yes, because the code in the module itself can be called within the formula, so naturally this information can also be returned.
However, it is important to note that this information is not text, it is a built-in error value!
The following table shows some commonly used error values for reference:

Constant

Error Number

Cell Error value

xlErrDiv0

2007

0 # DIV /!
xlErrNA 2042 #N/A
xlErrName 2029 #NAME?
xlErrNull 2000 #NULL!
xlErrNum 2036 #NUM!
xlErrRef 2023 #REF!
xlErrValue 2015 #VALUE!

returns the value by calling CVErr(error constant), so what you see on the interface is the error value we want to display.
Such as:
CVErr(xlErrValue)

SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED

The following errors occurred when importing data from the database to Excel using SSIS:
 
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
 
This is because the machine is 64-bit and there is no 64-bit OLE DB Provider.
Solution: Select Properties from the Project menu and Degugging on the left to set the Run64BitRuntime property to False. Then Execute Package, succeed.
 
Reference link: http://wenku.it168.com/d_000602554.shtml

Make: * * [emigen] error 255 error analysis

The error message is as follows:
> Make new
Clean EMI Settings
Generate EMI Settings
No type library matching “Microsoft Excel” found at./tools/ emigenv2.pl line 79
Win32::OLE(0.1707): GetOleTypeLibObject () is Not a Win32: : OLE: : TypeLib object at C:
/Perl/lib/Win32/OLE/Const PM line 49.
Win32: : OLE (0.1707) error 0 x800401f3: “” palawan/tools/emiGenV2. Pl line 225
the eval {… } called at./tools/ emigenv2.pl line 225
make: *** [emigen] Error 255

reason: according to the Makefile gsm2.mak description, emigen is dependent on sysgen, sysgen is dependent on cmmgen, and new dependent
cmmgen. So this error happens when you make new, Be emigen Missing several dependent files
custom/system/NEOTEL25_06B_BB/ custom_emine.c
custom/system/NEOTEL25_06B_BB/ custom_emine.h
custom/system/NEOTEL25_06B_BB/flash_opt.h
custom/system/NEOTEL25_06B_BB/ custom_switch_clock C

the make/Gsm2 mak
— — — — — — — — — — — — — — — —
new: cleanall cmmgen asngen codegen asnregen The update
cmmgen: sysgen
sysgen: emigen
emigen: $$(FLASH_OPTIONS_HDR) (strip) $$(CUSTOM_EMI_H) (strip) $$(CUSTOM_EMI_C) (strip) $$(SWITCH_CLK_C) (strip)
@ echo the Generate EMI Settings
@ if exist $$(EMI_GENERATOR) (strip)/
(perl $$(EMI_GENERATOR) (strip) $(strip $(PLATFORM)) $$(MCU_CLOCK) (strip) $$(MEMORY_DEVICE_HDR) (strip) $$(MEMORY_DEVICE_LST) (strip)) 2 & gt; & 1
— — — — — — — — — — — — — — — — — — — — — — —

the variable $(PLATFORM), $(MCU_CLOCK) have NEOTEL25_06B_GPRS. Mak is defined.
variables $(EMI_GENERATOR), $(MEMORY_DEVICE_LST), $(MEMORY_DEVICE_HDR) are defined in option. mak.

so if the above source file is missing, Then make will call./tools/ emigenv2.pl to execute
./tools/ emigenv2.pl MT6225 MCU_104M Custom/system/NEOTEL25_06B_BB/custom_MemoryDevice. H.
/tools/MemoryDeviceList/MemoryDeviceList_Since06BW0652. XLS

emiGenV2. Pl is a Perl script, which invokes the Win32: : OLE libraries for Microsoft Office Excel file parsing.
if Excel is not installed, the above error message will be generated. Reference

http://bytes.com/topic/perl/answers/681606-win32-ole-error-no-type-library-matching-microsoft-excel-found

summary: keep the source code file is missing source file, or install MS Office Excel.

Runtime Error 1004 Method ‘VBProject’ of object ‘_Workbook’ failed

症状

在Enterprise Performance Foundation Administrator中，当尝试使用位于“Configuration Rules”的“Create from Spreadsheet”按钮导入维度成员时;“维度”比;”成员”，以下错误发生时，您打开WebADI.xls

运行时错误’1004′:

方法’VBProject’的对象’_Workbook’失败

你在打开电子表格时选择了“启用宏”按钮。另外，在Excel 2003中，如果你打开“工具”>“宏”比;”安全…”，安全级别为”中等”.

解决方案

在Excel 2003中，转到“Tools”>“宏”比;“安全”，并选择“可信来源”选项卡。选中“信任访问Visual Basic项目”旁边的复选框。

(注意:还应选中“信任所有已安装的外接程序和模板”框。
在Excel 2007中，使用以下导航:

办公室李

    <>点击按钮在左上角李 <李>单击Excel选项按钮李 <>李在左边,点击信任中心李 <李>单击信任中心设置按钮李 <>李在左边,点击宏设置李 <李>单击“信任访问VBA项目对象模型”李

    转自:https://support.oracle.com/CSP/main/article?cmd=show&类型= NOT& id = 376013.1