I can open and save the Excel file if I use a mapped drive path, but not if i open it using the full path.
e:\sales\file.xls works fine, open, saves, re-opens.
\\server\sales\file.xls opens, saves and is then its corrupt.
I've experimented with this and its a consistent problem on 3 computers with various excel (2002, 2003 Small Buisness, 2003 Standard) versions and xp service packs (SP1, SP2, SP3). I also tried differnet opening methods, double click on the file vs excel>file>open>browse... and the only consistancy seems to be the path name. Has any one ever heard of anything like this?
To add a bit more info, this file starts as a template and our off site salesmen fill it out and e-mail it in. The problem only occurrs with files from one of our 8 salesmen. We've re-installed MS Office and updated all his software, but the problem presists.
Hi, everyone,
Please let me know any tips to reduce the size of an excel file. I'm have a file with several modules which generates an end report. I wanted to reduce the size of the file I remove the modules from the end report though...Is there anything else that I can do apart from this to reduce its size
Hi guys,
I am about to undertake a fairly large spreadsheet development project. One of the key requirements is that the size of the spreadsheet be kept to below 4mb, preferrably below 1mb. This is due to an unavoidable restriction.
Although the spreadsheet will not have large volumes of data, it will contain approximately 30 sheets. There are no graphics embedded in the sheet. I imagine there will be a reasonable amount of VBA and/or forumulas in the sheet. Each sheet will basically be a data-entry form with a number of formulas. No sheet will have more than 100 rows.
Without knowing the full details of the spreadsheet, it is difficult for you to give a definite answer as to the size of the sheet, so I am simply looking for some helpful tips in keeping the size down.
Do formulas take up more space than VBA code? When I format cells, should I format the entire row, or just the range? Do features like sheet and cell protection take up a lot of space?
Any other tips or suggestions?
Hello and thanks in advance.
Currently I download reports from a website and have developed a way to get the data I need into a seperate spreadsheet. Since I have three reports I download, I would prefer to operate out of a centralized spreadsheet (Inventory.xls) that pulls data from the others.
=COUNTIFS('C:\Users\BDC6\Desktop\Auction\Inventory\[WellesleyMazda.xls]Sheet1'!O$1:O$65536,"
I have installed an add in called RapNet06 that runs a macro to download diamond prices from an online price list that is periodically updated. Usually I will go to Add-Ins, click Fill in Rap prices and it will insert a column with prices based on the data already in the spreadsheet. However, somehow I have done something that has changed the filepath the macro uses to a network folder that it cannot locate. I have uninstalled the add in and then reinstalled it but it still points to the incorrect network folder.
So, my question is, how can I manually change the file path for an addin in Excel07? When I go to excel options/ Add-Ins the Rapnet06 add in is not listed... Any help is greatly appreciated!
I just wanted to know how I could obtain the file path for an excel file that is already open.
I'm having a littl edifficulty getting Excel to dynamically update from an
XML file. The XML file is generated from a program and I would like the Excel
file to dynamically update.
Problem is that the location of the XML and Excel file can change, that is
they can be anywhere on a hard drive but both are in the same directory. The
mapping of the XML file in Excel appears to be a complete file path
C:/data/report/.... but the location could change. They could be in
C:/data/report/run1 or run2, I don't want to have to re-map each time a
report is generated.
Ideally I would like to remove the directory specific path and use a
directory relative path. This way the XML file and XLS file can exist in any
directory and still update correctly.
Ofcourse, both files will be in the same directory when they are moved.
So my question is, can we change the path to teh XML file?
I'm using Excel 2003 (11.5612.5606) Office Pro.
Hello,
I created an add-in (.xlam) in Excel 2007 which has a number of user-defined functions. The add-in was deployed to a shared network folder as read-only so: (a) it could be referenced by multiple users at the same time and (b) we could easily deploy changes.
The individual functions within the add-in have worked properly and have thrown no errors.
The problem we are encountering is the functions often are proceeded by the folder where the add-in is located. So, users enter =GetFinancialValue(A1) -- where GetFinancialValue is a function we created. It initially works fine. Then, when the user closes and reopens the spreadsheet -- or sends it to someone else, the function is proceeded by: '\\servername.net\files\Software\ExcelAddIn\CompAddin.xlam'!GetFinancialValue(a1). The folder name is correct and may be referenced by all users. Why do this folder name occur? This causes the udf to not run and return #VALUE!.
We can resolve this by going into 'Data' --> 'Edit Links' and clicking 'Open Source' -- then everything calcs properly and the folder name is dropped from the udfs. But, the next time we open the file the same issue occurs again. Don't want users to have to do this every time they open a spreadsheet. When we click on 'Check Status' from the same 'Edit Links' dialog it displays 'Source is Open'
Thanks so much for any help you can offer. This is driving us nuts.
Thanks,
Dan
All,
I have a need to display the full file path name of a file into a given cell in a spreadsheet I am constructing. Whilst I know you can place it in the footer I was wanting it in a particular cell in a spreadsheet so that it can later be copied into a job ticket by an MI system
Any help as ever is appreciated
Best regards,
David
