Over 1 million tech questions and answers.

Excel 2010 workbook not saving...

Q: Excel 2010 workbook not saving...

Got a file that I can make multiple updates to, multiple saves. Then I make one more modification and save and.... it just WILL NOT SAVE any more modifications. Not a HUGE file, under 5,000 kB.

Suggestions?

RELEVANCY SCORE 200
Preferred Solution: Excel 2010 workbook not saving...

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2010 workbook not saving...

Read other 13 answers
RELEVANCY SCORE 88.4

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 83.6

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 81.6

Greetings,

Excel crashes every time I click the save button and "Excel encounter a problem and needs to close" error message pops up.

I ran an office repair--did not help.
Reinstall Office 2003--did not help.
XP pro, Office 2003 w/ all the updates.

Thanks.

 

A:Excel crashes while saving workbook form

Hi, welcome to the board!

Try uninstalling SP3.
 

Read other 1 answers
RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 70

Hi I have had office 2010 installed for about 2 months now but on a regular basis when I am working in Excel I am unable to save the document. When I select save or saveas nothing happens and when I close the document I am asked if I want to save and again if I select yes nothing happens. Currently my only workaround is to email the document to myself.

How can I go about reporting this to Microsoft or find a patch for this bug?

Regards,
DP

A:Excel 2010 not saving.

Have you installed the latest updates for Office 2010?

Read other 9 answers
RELEVANCY SCORE 69.6

I have a user that is having a similar problem to the one described in this thread: http://forums.techguy.org/business-applications/593620-solved-excel-password-protected-files.html

The difference is that she is having this problem in Excel 2010. I tried navigating to File > Options > General and then removing her name from the 'Username' field, but after saving the workbook, closing Excel and then trying to open the workbook again, she is prompted by Office to enter her name and initials. Even if we delete her information from here and click 'ok' the password prompt comes up (as it should) but still shows '<file name>' is reserved by <user>...

The workbook was originally created as an Excel 97-2003 workbook and apparently has macros; I tried saving it as a .xlsx but had to save it as a macro-enabled .xlsm file. I then tried the same steps to remove her username, but this did not resolve the issue.
 

A:Excel 2010 password protected workbook "reserved by <username>"

Just a bump since there has been no response
 

Read other 3 answers
RELEVANCY SCORE 68.8

I have the following issue every time I try and save one excel workbook that was sent to me and I need to work on it frequently it will not save.

The OS that I&#8217;m running is windows 7 Professional 32bit the office application is MS Office 2010 Standard. Every time I try save the file I get the following error &#8220;Errors were detected while saving &#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. Microsoft excel may be able to save the file by removing or repairing some features. To make the repairs in a new file click continue. To cancel saving the file click cancel.&#8221;

If I click continue Excel freezes up and has to be shut down via task manager if I press cancel it does not save the document. Now I have checked the following on the document.

Permissions on the excel workbook are go

Disabled add-ons on excel

Changed Excel file name

Change file to 2003 format and still having same problem as 2010 format

Cleared all Temp files form the temp Folder

Opened the excel file using the open and repair feature

Uninstalled and reinstalled MS Office 2010

Performed a repair on the installation

All other excel files work fine on this computer I have created new workbooks and saved them without any issues I have emailed the file to a different PC with the same specs and can save the file fine without having to make any changes to the system or excel file.

Is there anythi... Read more

A:Excel 2010 Saving file problem

Is the file from previous version of excel?
I once have such issue, only to find out and old macro code causing the problem.
one such error will be having range = something instead of set range = something.
Compiler will not throw out errors of such.
 

Read other 2 answers
RELEVANCY SCORE 68

I have setup excel pie charts whereby I only want the data label option “percentage” to be shown. If I save the workbook with these settings, close and then re-open the settings are retained.

When I then upload this workbook to my SharePoint 2007 site and select open, open snapshot in excel the workbook opens, but all other data label options are set such as series name, category name, value, as well as percentage (percentage option is all I want, and the only one i set).

If I choose the option “open the workbook in excel” the data label options are set correctly. I need to be able to open the workbook as a snapshot, with the correct data label options because the other option to simply open in excel through SharePoint strips out all the formulas which reference particular data.

The odd thing with this is that if I open the snapshot in Excel 2007 the correct data label options are retained (series name, category name, value) are unticked, which is how I set it.

I tried re-building the excel workbook again in excel 2010, but I’m having the same issue.

I tried with a simple pie chart and the same happens.

We are using Excel 2010 X86 SP1 and SharePoint enterprise server 2007

Any help would be appreciated.
 

Read other answers
RELEVANCY SCORE 68

When I try to save a file to a folder I have in MS Excel 2010 I don't see all the that are really in that folder. Only the last 10 or so are there. My boss is trying to save an excell document into his Project Folder but when he hits save as only certain documents show up and none of them are the Folders that are definately created and can be accessed when you go to Windows Explorer. Is there a way to change this?
 

A:MS Excel 2010 - Saving File - Can't see all folders in Save As

Read other 10 answers
RELEVANCY SCORE 66.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 66.4

I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft Excel has stopped working. The first window reads that it is checking for a solution to the problem. Then it pops up with a second window within 2 seconds and it reads - A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.

The user that received this spread sheet is using 2003 and can not open it at all. It comes up with the window - trying to convert - and then says it can not convert the file.

I am using windows 7 64 bit with office 2010 Pro and all updates have been installed.

Thanks
Joel

A:problem saving excel spread sheet in 2010 to 97-2003 format

Hi Muskiehunterjoe, welcome to Seven Forum.

You could try running the Compatability Checker or temporarily change the default save option:
Dealing with Excel 2010 File Formats - For Dummies






Quote:
Running the Compatibility Checker

You also can run the Compatibility Checker in Excel 2010 to find any potential compatibility issues if you plan to save the file in the Excel 97-2003 file format. To use this feature, follow these steps:
In Excel 2010, open the workbook you want to check.
Click the File tab, click the Check for Issues button on the Info tab (on the left), and click Check Compatibility.
The Microsoft Excel ? Compatibility Checker dialog box appears. Any features that might cause issues are listed in the Summary box.
Click OK to close the dialog box.
If you?re working in an office where all the workbooks you produce with Excel 2010 must be saved in the old Excel 97-2003 file format for compatibility, you can change the program?s default Save setting so that the program always saves all new workbooks in the older file format. To do this, open the Save tab of the Excel Options dialog box (File→Options→Save) and then select Excel 97-2003 Workbook in the Save Files in This Format drop-down list box.

Read other 7 answers
RELEVANCY SCORE 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 56.8

For the Excel gurus out there. Let me know if this is possible.

We are running WinXP with Office 2002/2003 in our office. There is a shared excel document that is used/edited by 4 people at the same time. They copy info from their Lotus Notes into Excel and then use the text to columns feature to separate it across a few columns. This is used as a log for the work they do every day. One user was upgraded to Win7/Office 2010. When he opens the file and copies the info from his email, text to columns is grayed out. If I turn off the shared workbook option, he is able to use text to columns. I called out help desk and after 2 days, they called me back and said it can't be done. Is this true? Why would a function be taken away in the newer version? I was told this was also in Office 2007. Please let me know what you find out.

Thanx,

Chris
 

A:Text to Columns - Shared Workbook (Office 2007/2010

I doubt that the function is 'taken away' you must realize that if one person is working with 2010 and the rest with 2003 or earlier, there is a problem with comapatability issues and therefore some default actions may be greayed out.
 

Read other 3 answers
RELEVANCY SCORE 56.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 56.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 56.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 56.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 56.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 56.8

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vessel’s name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename – based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

 

Read other answers
RELEVANCY SCORE 56.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 56.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 56.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 56.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 56.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 56

I'm having the dreaded "shared workbook" issues.
 
I have many users at different points in the week complain about issues with a shared workbook. May it be slow to open, slow to save, random crashing, loss of data, loss of changes, I get it all!
 
I've found going to each computer to try to diagnose and/or repair excel is futile. Does anyone have any insight as to how I can get around this? I was thinking either find out how to use Microsoft Access with their workbooks or convincing the management to assign one person in their team to do the excel spreadsheet updates.
 
Your help will be GREATLY appreciated.

A:SHARED EXCEL WORKBOOK CORRUPTION

Just got off the phone with Microsoft which was no help. It seems like there are no fixes whatsoever for this issue. I'm leaning more towards using Access with the workbooks to alieviate this issue. However any help will be appreciated.

Read other 1 answers
RELEVANCY SCORE 56

This is a followup to my "Data transfer between 2 different open Apps" thread, which is now functioning...sort of. I have not found a way to access the data from the workbook which is opened in the second application. I can only reopen it from it's last saved location, which is OK, if I know that the workbook has not been changed since it was last saved. Part of what I'm doing uses a IsFileAlreadyOpen function (kernal32) as recomended to me in that thread.

QUESTION: I would like to know if an open workbook has been changed since it was last saved. This workbook is in a different app. Is there a function (perhaps kernal32) that can be called to give me the changed state of a workbook?
Thanks,
Tom
 

A:VBA Excel: Check if a workbook has been changed

Read other 7 answers
RELEVANCY SCORE 56

Hi,
I have on a workbook many sheets.
Every sheet contains tables with SUM A formula.
I want to create a cell on a different sheet where it gives me the SUM of all the cells on my workbook where the SUM A formula has been implemented.
Is that feasible?

Thx
 

A:excel 2007 (SUM FORMULA on all workbook)

Read other 6 answers
RELEVANCY SCORE 56

It seems to me that I used to be able to set up my own default Excel books and worksheets. I would set formats, toolbars, footers, etc. the way I liked them then save the sheet as “sheet1.xlt” and the workbook as “book1.xlt”, and put these in the XLstart folder. That way, when I opened a new workbook, or inserted a new sheet, the sheets are formatted they way I want them. But that doesn’t seem to work now. I’m using Excel 97 and Win XP. Before I was using Excel 97 and Win98. Did I miss a cog somewhere? It’s been a long time since I did this and perhaps I missed a step.

Don
 

A:Excel 97 Default Workbook/Sheets

Read other 6 answers
RELEVANCY SCORE 56

Microsoft Excel 2003 - I need help creating a macro that will link a workbook file with hundreds of other workbooks to create a customer list. All my workbooks are in C:\Documents 2007\Bids\BID____.xls. All files begin with "BID". All workbooks are identical and I only need information from certain cells. (i.e. G8, A6, G6, etc.). I want all the information from each file to go onto one row of the customer list - a new file's information on each row. Does anyone know how to do this? I have spent all day working on it and am about to go out of my mind. I would really appreciate any help. Thanks.
 

A:Excel - Need Workbook Linked to Many Workbooks

Read other 16 answers
RELEVANCY SCORE 56

I have recently bought a new computer and gone from Windows 7 to Windows 10. In addition , I have changed from Office Home and Student 2007 to the 2019 version. The other day , when I tried to load an Excel file (.xlsm) that I have used quite happily before on my previous computer , I got an error message which read as follows :
"Code in this project must be updated for use on 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute"

I developed the workbook some years ago with a lot of help from Tech Support Guy contributors and I am quite ignorant of this latest issue. Is there anyone who can help ?
 

Read other answers
RELEVANCY SCORE 56

I have an Excel macro that opens another workbook. If the macro errors out, how can I close the second workbook that was opened?
 

A:Excel Macro -> Close Second Workbook

Read other 12 answers
RELEVANCY SCORE 56

I have a audit template that takes two files and compairs them and opens a new workbook to display the differences. This new workbook is then saved to a specific location for audit reasons.

In the new workbook created, I'm wanting to "remove" all the toolbars and menus so a user can't safe the file to another location by mistake.

Is there a way for the creating template to "insert" macros into the newly created workbook to do this? While I could just create new worksheets in the "creating" template workbook and remove the ones I don't need, I'm trying to keep the size of the file down by not having all the macros that created the new template in the final product.
 

A:Have Excel VBA Create A Macro In A New Workbook

Just for some thoughts on this concept, I would suggest you read this:
http://www.vbaexpress.com/forum/showthread.php?t=26263&highlight=hide+toolbars
 

Read other 1 answers
RELEVANCY SCORE 56

hi all,
I have an excel workbook with several worksheets, each a page a long (i dont want them all merge in one sheet). I need to number them sequentially as they appear on the workbook.
The only way i can number them now is by going into each worksheet and inserting a page footer and enter a number manually !

Is there a way whereby all worksheets/pages are numbered automatically and more importantly page numbers changes if a new sheet is inserted ?
Thank u kindly.
Edd.
 

A:Excel - Workbook page numbering

Read other 12 answers
RELEVANCY SCORE 56

I am copying an excel worksheet from an existing workbook to a new workbook using a macro. The sheet contains a Private Sub. I want the new workbook to have the Private Sub password protected. Is there a way of writing this into the macro of the originating workbook?
 

Read other answers
RELEVANCY SCORE 56

Good morning,

My head office has implemented a new way of recording operatives working hours.

It used to be based on a persons name and then the number of hours worked on a job. You could get about 20 men on one sheet.

Now thy want it based on the Job so each job has its own sheet, so we are swimming in paper!

What I need is a page where I can have a drop down box with the following criteria:

Name
Trade
Week Ending

and then

The jobs that that person did, so:

The Job
The day
The Number of hours

I dont want to manually enter all of this in a load of different spreadsheets so i there a way of just using one and when i hit 'Enter Data' or something it populates pre-made spreadsheets that I can print?!

Ive attached what ive got so far.

Regards
James
 

A:Excel - Using one Workbook to populate information in another

Read other 16 answers
RELEVANCY SCORE 56

Please forgive me if I am using incorrect terms here. I use Adobe Acrobat/Distiller (Version 5) to convert documents to pdf format. The problem comes when I have a large Excel workbook with 20 or so worksheets (tabs at the bottom of the page). When I try to convert them into pdf (File-Print-Distiller) I get 20 or so files.

First question-Is there a way to convert a multiple worksheet excel file into 1 pdf file? (Without the tedious "insert pages" function I am using right now)

Second question- Is there a way to convert multiple Word documents into 1 pdf file? (Once again without tedious "insert pages" function) Before you ask, no I cannot make all the Word documents into one file.

Third question-If there is no way to do the other two...is there a way to convert multiple adobe pdf into one without "insert pages".

Now since last time I got a bunch of "if it's not broke don't fix it comments" I am posting this statement. "Insert pages" is great and works great to get a couple of pdf files together. Try doing it for over 250 files and see how fun it is.
 

A:How do I print an entire excel workbook to pdf

If the worksheets are all < 1 page "long", then File -- Print -- Entire Workbook worked for me using CutePDF (can be found on Google).

OpenOffice has "Export to PDF" ; it did handle > page-long sheets for me, but baulked at some print settings, so it could depend on how fancy your sheets are (http://www.openoffice.org/).

>> I cannot make all the Word documents into one file.

Are you saying Insert Subdocument doesn't work in your version of Word?

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 56

Greetings everyone,

I have a question I am hoping you can help me with.

I create Excel reports, where the first sheet is a Menu and a second sheet contains data. The Menu refers to the second page, and based on which options the user selects on the Menu, a graph on the menu page updates with the relevant information from the second data sheet.

I am wanting to publish this Menu sheet such that it can be accessed and used on a webpage -- therefore, it needs to refer to the second sheet. However, I would like to keep that second data sheet 'locked' so that it cannot be accessed on the webpage at all.

Is this possible?

(PS - I know I have to use Excel 2003 to publish an interactive workbook ... unless anyone has discovered a way to do this with 2007, which dropped this great feature).

Many thanks in advance.
 

A:Publishing interactive Excel workbook - help please

You could make the sheet Hidden or via code XLSheetVeryHidden but the data will always be available.
 

Read other 1 answers
RELEVANCY SCORE 56

Using Excel 2010. I regularly download data from a database which have to be sorted by

column 1 - cell color blue on top, then
column 1 - cell color orange on top, then
column 4 - value, from newest to oldest

the data is always downloaded automatically to a workbook named "ABC", and the worksheet is always automatically named ABC#, with the # changing automatically.

the macro is saved in the personal folder. I tried to record using absolute and then as relative reference. the macro NEVER works when I tried to run in any new downloaded workbook or even I recreated the same data in a new untitled workbook.

the number of columns is always the same but the number of rows varies. there are about (7) cell colors, but only the blue and the orange need to be on top

the recorded macro always indicate the name of the worksheet and workbook on which it was created. is this why it does not work on any other workbook or worksheet?

any help will be appreciated
 

A:Excel Macro Won't Open in Different Workbook

Read other 14 answers
RELEVANCY SCORE 56

I have a workbook that I want to share with many people so they can all edit at same time. When I share it, they cannot run macos, it errors out with

"Error 1004 Application defined or object defined error"

Any ideas on how to overcome this?

Thanks!
ASM
 

A:Excel - Shared Workbook Macro

The macro is supposed to create hyperlinks... is this a no no? this is excel 2007...
 

Read other 1 answers
RELEVANCY SCORE 56

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

Read other answers
RELEVANCY SCORE 56

I have an employee who says that when he has macro errors in his excel 2000 workbook and it debugs the file it crashes and does not save the workbook changes. Any idea why?

Just wondering,
KHeinz
 

A:excel 2000 - Workbook not saved

Moved this to Buisness, where you may get more responses
 

Read other 2 answers