如何在Web服务器上保存Excel文件时解决[1] IE错误? [英] How to work around the [1] IE bug while saving an excel file from a Web server?
问题描述
我注意到Internet Explorer在从互联网下载的文件(通常为[1])中添加了一个方括号。在Excel工作表名称中,方括号不是有效的文件名字符时,会导致下载Excel电子表格的一个大问题。那个问题是IE特定的,其他浏览器保持相同的文件名。
所以,如果你有一个数据透视表在文件打开时自动刷新,你会得到
是否有任何解决方案?
$一个错误消息说,名称file [1] .yourPivotTableName无效。编辑:看起来,无论HTTP指令建议的文件名,IE都会在所有情况下添加[1],从而导致问题! (所以关于文件名的答案在这种情况下是没有帮助的)
编辑:当我打开一个VBA代码时,我尝试使用另一个名字保存文件。但是,它不起作用(与之前相同的错误消息)。你有没有办法用VBA来解决这个问题?
我已经使用这个很酷的人提供的VBA (喜欢他)
它重命名文件,然后重新连接枢轴。
http://php.kennedydatasolutions.com/blog/2008/02/05/internet-explorer-breaks-excel-pivot-表/
I've noticed that Internet Explorer adds a number in square brackets to files downloaded from the internet (usually [1]). This creates a big problem with downloading Excel spreadsheets as square brackets are not a valid filename character inside Excel worksheet name. That problem is IE specific, others browsers are keeping same file name.
So, if you have a pivot table auto-refreshed on file opening for example, you'll get an error message saying the name "file[1].yourPivotTableName" is not valid.
Is there any solution to that problem ?
EDIT : It seems that whatever the filename suggested by HTTP directives, IE adds [1] in all cases, which cause the problem ! (So, answers about filenames aren't helpful in that case)
EDIT : I've tried some VBA code to save file under another name when it'll open. However, it doesn't work (same error message than before). Do you think there's a way to fix that with VBA ?
I've got it working using VBA provided by this cool guy (think of him fondly). It renames the file and then reattaches the pivots.
http://php.kennedydatasolutions.com/blog/2008/02/05/internet-explorer-breaks-excel-pivot-tables/
这篇关于如何在Web服务器上保存Excel文件时解决[1] IE错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!