Over 1 million tech questions and answers.

Excel 2000 .. When saving a certain workbook excel crashes

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

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

RELEVANCY SCORE 200
Preferred Solution: Excel 2000 .. When saving a certain workbook excel crashes

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 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 122

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 102.4

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?
 

A:Excel 2010 workbook not saving...

Read other 13 answers
RELEVANCY SCORE 97.6

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
RELEVANCY SCORE 89.2

When I check Save a file every 30 minutes it always prompts me - even tho I checked not to.
Also I save after each use but when I open the spreadsheet the next day it always opens in the first cell rather than where I saved it from.
Any help on these problems.
Just annyoying especially when I have huge spreadsheets and have to find my way to the end every time I open it.
Thanks.
 

A:Saving in Excel 2000

Well, I had something similar to your problem not so long ago, but I had found out that I hadn't configured it properly, so I just advise that you check the configuration is all fine!
 

Read other 1 answers
RELEVANCY SCORE 88.8

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 88.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 87.6

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 87.2

Hi

I have an excel spreadsheet with a picture. I would like to know how to save this picture to a file. I am trying to find a way to do it manually, but eventually I will need to be able to write the VB code to save the picture to a file.

Any ideas?
 

A:Saving a picture to a file in Excel 2000

Well, until someone gives you a VB answer, you can always right-click it, choose Copy, and then paste it into a graphics viewere and save it from there.

IrfanView is a great, free, graphics package.
 

Read other 1 answers
RELEVANCY SCORE 87.2

I use Excel 2000 but need to send a spreadsheet to someone using Win98 and "Works". How can I save this file so that he can use? Thanks
 

A:saving Excel 2000 files for use in Works

Either export it to word or open word and import the file, then when you save it save it in the works format.

That should work.
 

Read other 1 answers
RELEVANCY SCORE 87.2

I work in an engineering firm where we share almost all of our excel spreadsheets. We have been noticing that excel will not always save the information of the person who did not exit last. They say they have been telling the program to accept all their changes, but it does not. Any ideas why?
Just wondering,
KHeinz
 

A:Excel 2000 - Not saving shared information

Closing duplicate, please reply here:

http://forums.techguy.org/t161702/s0998536ac37fb7f5265b896290cd3110.html
 

Read other 1 answers
RELEVANCY SCORE 86.4

I've recently encountered a problem saving Excel files that contain comments. This happens if I open an existing file with a comment, edit it and save it, and also with a newly created file that I add a comment in a cell to.
 
What happens is I get a circling cursor and after a bit a message saying that Microsoft Excel has stopped working. In the directory where I tried to save the file a 0 byte file is left with a name that appears to be several random numbers and no extension. If I remove all comments from the Excel file, it saves fine.
 
I am running Windows 10 64 bit (creators edition) and Office 365 Home.
 
I took the following steps to try to resolve the issue:
 
1. I did a quick repair on Microsoft Office - no help.
2. I did an online repair off Microsoft Office (this seems to reinstall all of office) - no help
3. I went back to a restore point that I believe was prior to my experiencing this issue - no help and I have no earlier restore points to try.
 
Can anyone help?

A:Excel crashes when saving files that contain comments

Does file cause the same problem on other computers? Or is it only on this computer?Have you actually tried completely uninstalling Office and then reinstalling it (even though the "repair" seemed to potentially do that)?Have you tried doing a "Save As" to a different file name with the comment's included?

Read other 8 answers
RELEVANCY SCORE 86

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 85.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 82.8

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 81.6

I have an Excel program running that records data and saves at the end of each day(12:00am). Every now and again the program locks up with no means of looking at the VB Code or the sheets, all I can do is shut it down and with that I get the Error log has been created... message. My question is anyone experienced something like this, and is there a way to find out what the error log contains? My thought is the error log may give some kind clue to the problem.
Thanks in advance for any advise.
Eric
 

A:Excel 2000 crashes and creates Error log

Read other 16 answers
RELEVANCY SCORE 78.8

I have a friend who is suddenly experiencing an issue where they are no longer able to Open an Excel file through their Windows Explorer (e.g. when trying to open a Excel file from within their My Documents folder). After double clicking on the file, Excel opens and acts as if it is opening the file but then proceeds to show just a blank worksheet. The file does not appear to be corrupt since they can then go to File/Open from within Excel, locate the folder and then Open it without a problem.

Any suggestions? Any ideas would be greatly appreciated as to the cause and resolution for this.

Thank you greatly,

Mike
 

A:Excel 2000 - Unable to open Excel file thru Windows Explorer

Check this out: http://www.pcreview.co.uk/forums/thread-1781119.php
 

Read other 1 answers
RELEVANCY SCORE 78.8

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

Read other 3 answers
RELEVANCY SCORE 78

I'm having a problem with Excel 2000. Randomly it corrupts the file that I save to a network drive...I can save it but I cannot open it again. I get an error message "Out of Memory" It doesn't do it all the time and generally with large Excel files. I'm running Win98 and have installed all the Service Patches for both Win98 and Office 2000. Other people in the office can save to the same network drive with no problem.
 

A:Excel 2000: Out of Memory on Opening Excel Files

I would do both of the following:

Low memory (resources) error message
1. Go to "Start".
2. Then click on "Run".
3. Type in "msconfig" without the quotes.
4. Click "OK".
5. Put a check in "Selective Startup"
6. A window will open, click on the "Startup" tab.
7. Uncheck all programs that you do not need running when the computer starts.
8. These leave checked, "Sys tray" and "Scan registry".
9. Depending on your machine you might have video or sound listed also.
10. All you can do is uncheck them one at a time until you get the one needed.
11. These are programs running in the back ground and will kill your resources so you do not want any more running than you have to.

Low Memory (resources) error message with Office Application:

1. Run detect and repair in Word.
2. When it ask about rebooting to finish repairing click NO.
3. Reboot to "MS dos" prompt.
4. At the C:> prompt type in deltree /y temp\
5. Click on enter.
6. At the C:> prompt type in del *.swp
7. Reboot to windows.
8. After it reboots right click on "My Computer".
9. Then click on "Properties"
10. Then click on the "Performance" tab.
11. Then click on "File System" and set it to "Network Server" under "Typical role of this Computer".
12. Then click "OK".
13. Then click on the "Graphics" tab and set it to ¾.
14. Click OK.
15. Rebo... Read more

Read other 1 answers
RELEVANCY SCORE 78

I have a document created in Excel 2000 with many sortable rows. It responds quickly in Excel 2000 but when I hope it in Excel 2007, it is very, very slow.

Is there a way to solve this for use in 2007? Take off filters then re-add?

The computers are brand new Core 2 Duos. Thanks!
 

Read other answers
RELEVANCY SCORE 77.2

Hi, I have created an excel macro that runs sensitivities in my model. The excel button runs 5 different cases.

The macro runs fine and does as I want it to.

Once the macro has run, and I go to edit a cell and hit "F2" excel crashes. This only seems to happen in certain cells and not all of the time.

Does anyone have experience with similar questions?

Thanks
 

A:Excel Macro runs fine..then excel crashes

Read other 11 answers
RELEVANCY SCORE 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 77.2

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 76.4

When I bought my newest computer, it had MS Office 2007 installed.
My data from Excel 2000 was backed up and downloaded to my new computer.
The company I bought my new computer from transferred all my data for me.
Problem is:
all the old Excel data is still coming up as Excel 2000.
Question:
Is there a way to convert the old data to Excel 2007?
Business workbook has much much data that I need to get ready for a new year soon and I'd like to use the Excel 2007 for this?
Thank you for your help.
 

A:Solved: Excel 2000 to Excel 2007

After you have opened an Excel 2000 file, do a 'Save As' to the new 2007 format.

lol
Hew
 

Read other 2 answers
RELEVANCY SCORE 76

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 76

hi,

i have a Excel workbook that consist of 3 worksheets and there are some formulas in each of those sheets.

the problem is that each time I open the workbook there will be a "update link" message that appear (pls see the attachment). that's strange 'cause I have never inserted any links before.

is there a way to display all the links that are present in the worksheet and prevent this message from re-appearing?

thank you
 

A:Cannot Find the Links in Excel Workbook

Try Bill Manville's add-in -- http://www.oaltd.co.uk/MVP/MVPPage.asp
 

Read other 2 answers
RELEVANCY SCORE 76

I have a non-shared Excel spreadsheet that users have saved multiple copies of.  Some are Excel 2010 and some are Excel 2003.  I need to compare and merge them back into one spreadsheet which I will then share.  What is the best (and easiest!!) way to do this?

A:Merge Non-Shared Workbook in Excel

sounds like a manual job.... you can't automatically select the best data over a range of different spreadsheets.
 
As long as the macros were created with the 2010 version you should be able to view them within the same instance of Excel.

Read other 1 answers
RELEVANCY SCORE 76

Hi,

I have Excel 2007 and want to use MS Outlook 2007 for emailing. However, I do not want to email the whole workbook but only one sheet,or sometimes just a small selection and this does not seem possible at the moment.

I can copy one sheet over to a new workbook and then email the new workbook but I wondered if there was a quicker way to do it. I have heard that there are Add-Ons that can be downloaded which allow for only one sheet to be emailed. I found one called RDB Mail but as I went through the procedure I got warnings that it may have been an unsafe site so I did not continue with it.

Does anyone know of a safe way to do this? And, has anyone heard of RDB Mail (I found it on a Microsoft site) and, if so, is it safe?

A:Emailing only one sheet from an Excel workbook

Have no idea about RDB Mail. As for emailing one sheet? Does it have to be as an attachment, or can the sheet be embedded in the email?
If it can be embedded try the following for emailing from Excel:

Step One: Next to the save icon there is an icon that looks like a letter and envelope. Click this icon.
Step Two: Excel will prompt, and ask if you want to send just the active page/current sheet, or the entire workbook.
Step Three: Excel should copy the sheet to a new email message in your default email program.

If the spreadsheet needs to be an attachment? I don't know of any other way than creating a new single sheet workbook as you stated.

Maybe someone else has a tip or clue I'm unaware of.

Read other 6 answers
RELEVANCY SCORE 76

When I try to delete either in Excel 2016 I get a message that tells me to unhide the sheet. The sheet is there in front of me, the "hide/unhide" says nothing is hidden and I am confused. Can this be resolved?

Also, how do sheets get hidden without my doing anything knowingly?

Thanks
 

Read other answers
RELEVANCY SCORE 76

This may be too simple for some but I have a difficult task ahead of me. For some dumb reason our company refuses to let certain individuals use the database information of our time sheet software. Well this makes scheduling time off a nightmare. Hopefully there is someone who uses or can recommend a spreadsheet format (excel??) that can keep track of scheduled days off. And those days already used. We have several different types of payed time off kept in different types of banks and employees have to schedule way in advance and sometimes use one bank up and schedule another day off from that bank but end up redoing the request because they don't have time in that bank and have to reschedule. Creates a lot of paperwork and time adjusting. Example... most get 80 hours of vacations, 32 hours of what we call eat days (no lunch paid so we get 4 days off - eat days), 80 hours of Holidays. Those are fixed banks for the calendar year and then we have a COMP bank used where they can acquire hours from overtime or extra hours worked training which are based on using during an employee's anniversary year. Then we have a Holiday Bank which is never ending (no end date to be used by - no anniversary/year date) can be added to by 4 hour increments if you work a holiday. All of these hours are paid at the same wage. It really doesn't matter how you use the hours but they have to be approved prior to taking off depending on scheduling needs. What I would like is some sort of... Read more

A:Tracking days off with an Excel workbook?

Read other 8 answers
RELEVANCY SCORE 76

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 76

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 76

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 76

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 76

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